J
JamesJ
Access 2007
I have the following code in the On Current of my form
Dim intNewrec As Integer
intNewrec = IsNull(Me.DvdMovieID)
If intNewrec Then
lblCount.Caption = "***New Record***"
Else
lblCount.Caption = RecordsetClone.RecordCount & " Items"
End If
When the form initially opens lblCount displays "1 Items" until I select a
record then
the correct number of records are shown. The same code is in othewr forms
with no problems.
Any ideas?
Thanks
James
I have the following code in the On Current of my form
Dim intNewrec As Integer
intNewrec = IsNull(Me.DvdMovieID)
If intNewrec Then
lblCount.Caption = "***New Record***"
Else
lblCount.Caption = RecordsetClone.RecordCount & " Items"
End If
When the form initially opens lblCount displays "1 Items" until I select a
record then
the correct number of records are shown. The same code is in othewr forms
with no problems.
Any ideas?
Thanks
James