I have used below code to make each record on form as an week number for my
maintenance schedule access datebase.
Below is code used
Private Sub Form_Current()
Dim rst As DAO.recordset
Dim lngCount As Long
Set rst = Me.RecordsetClone
With rst
.MoveFirst
.MoveLast
lngCount = .RecordCount
End With
Me.txtRecordNumber = "WEEK NUMBER " & Me.CurrentRecord & ""
End Sub
I would like to open the form with the correct week number for the current
date and / or be able to type the week number before opening form.
Is this possible??
