H hardhitter06 Registered User. Local time Today, 02:57 Joined Dec 21, 2006 Messages 600 Jan 3, 2007 #21 It seems that the save button is saving the records, but giving that error message...?
S Scottyk537 Registered User. Local time Today, 01:57 Joined May 25, 2006 Messages 48 Jan 3, 2007 #22 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
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
H hardhitter06 Registered User. Local time Today, 02:57 Joined Dec 21, 2006 Messages 600 Jan 3, 2007 #23 I GOT IT!!!..yea it was the ( ) causing the confusion. Thank you so much for your help and patience.
H hardhitter06 Registered User. Local time Today, 02:57 Joined Dec 21, 2006 Messages 600 Jan 3, 2007 #24 Scott, Do you have any insight on this thread http://www.access-programmers.co.uk/forums/showthread.php?t=119926
Scott, Do you have any insight on this thread http://www.access-programmers.co.uk/forums/showthread.php?t=119926