Requery problem

wannabe

Registered User.
Local time
Today, 07:43
Joined
Feb 13, 2000
Messages
14
I have a tab control on my main form, and subforms on the different tabs. On the tab/subform I also have a command button to add a record to the subform. This works great.
My problem is that when I close the pop up form after adding a new record, the added record does not appear on my subform until I back out to the menu and then re-access the form with the subform.
I have tried
Forms!frmMainForm.frmSubform.Forms.Requery
(which I might add, I'm using elsewhere in my program, only not on a tab control)
I have this code added to the Activate Event on my frmMainForm but when I try to load the form I get the infamous
Run-time Error 2465
Application-defined or Object-define Error.

Can anyone help me out with this. I running into a deadline and really need this working.
TIA,
Emily :confused:
 

Users who are viewing this thread

Back
Top Bottom