Requery Combo Box

[Peter K]

I am also posting this here becasue no one answered it in
the Query section.

I have a form where a user inputs data. Many of the
fields are combo boxes that are linked to a duplicate
query in order for the user to have access to previously
entered information instead of always rekeying it. I want
this information to be updated upon every new record
addition. I have a macro that "requeries" those in the
main form but I can't get it to work in the subforms.
The combo box is used in a subform on a Tab control.
Please advise and be specific if possible.

THX in advance

 

[Mark Phillipson]

Peter,

See http://www.mvps.org/access/forms/frm0031.htm

Hope this helps.


--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/

 

[Peter K]

I have tried almost every combination of these codes an
none of them have worked. I give up...the users can close
the form if they have to.