There is refresh and there is refresh all. refresh = the immediate record you are in(where the cursor is.
Refresh All = all the records, thus taking you back to the beginning of the recordset.
hope this helps.
I have a form with one subform. I want to test the subform for records after I update the Master Form. Such As:
If Me.subform is Null Then
do this
Else
End If
I've tried If is Null *** and If Not Empty*** what is the proper syntax? I know I've done it before.
Please help....