Forms

It seems that the save button is saving the records, but giving that error message...?
 
You shouldn't use () when naming forms, queries, controls, etc. It gets confusing in VB.
add [] to get around this:
[Forms]![frmDept(Search)].Requery

I don't know why you have this code after but I REMED in out:

' Screen.PreviousControl.SetFocus
' DoCmd.FindNext
 
I GOT IT!!!..yea it was the ( ) causing the confusion. Thank you so much for your help and patience.
 

Users who are viewing this thread

Back
Top Bottom