I have a split form that recently developed a problem.
when the form first opens, the active record is record #0 , I have no record 0 in my database. However, on the displayed form it shows the data for my first real record. and in the split (datasheet) portion of the split it shows all of my records.
When the form is first opened the on-current event doesn't seem to fire either (verified with a msgbox in the VBA event)
and
If I try to use my command buttons for "next", "previous", "last"and "first" records, I get an error "You can't go to the specified record"
I've added some debug.print code to verify that the record is actually zero as follows
the results are:
Name: frmAssets
ME Name: frmAssets
Recordsource: qryAssets
Record #: 0
Record Count: 1153
when the form first opens, the active record is record #0 , I have no record 0 in my database. However, on the displayed form it shows the data for my first real record. and in the split (datasheet) portion of the split it shows all of my records.
When the form is first opened the on-current event doesn't seem to fire either (verified with a msgbox in the VBA event)
and
If I try to use my command buttons for "next", "previous", "last"and "first" records, I get an error "You can't go to the specified record"
I've added some debug.print code to verify that the record is actually zero as follows
Code:
Private Sub Command108_Click()
Debug.Print "Name: " & Me.Application.CurrentObjectName
Debug.Print "ME Name: " & Me.Name
Debug.Print "Recordsource: " & Me.RecordSource
Debug.Print "Record #: " & Me.CurrentRecord
Debug.Print "Record Count: " & Me.Recordset.RecordCount
End Sub
Name: frmAssets
ME Name: frmAssets
Recordsource: qryAssets
Record #: 0
Record Count: 1153