Access problems with inputting new records by subform

[Puffin]

I have created a main form with several tabbed subforms. When I add a new record the details on the main form are stored, but when I go to a subform I get a message saying that data can not be added as duplicate values are created. I have checked this and it does not seem to be the case. If I exit the form and reenter I can add the information to the subforms without any problems. Bizarre or what. Please help

 

[Andrew Fergus]

Hello and welcome.

I can't answer your question directly but I have seen similar problems resolved by "requerying" the form when it becomes active. Have you tried doing this? Even if this doesn't solve your problem, your post will now get "bumped" and someone else may be able to help.

Andrew.

 

[Puffin]

Yes requerying the form does work. This is fine for when I am inputting the data. But I am hoping my colleagues will also be inputting data. It would be much easier if the form worked the first time.
Puffin

 

[Andrew Fergus]

Oops - sorry for not explaining myself 100% - when I mentioned "requerying the form" I meant via a macro attached to the form properties. It is possible to create a macro with two commands (i.e. requery and stop macro) and then include it in one of the "event" properties while in the form design mode - I'm not sure which "event" to use for tabbed subforms (something like "On Load" or "On Open"?) - apologies for being so vague.
Andrew.