Conbo Box selection to be entered into a new table

[PST]

My Combo Box works and displays new entries in text boxes in my form. The selection appears in every record. I would like the selection to be stored only in the displayed record and not for each and every record. Any ideas?

My combo box works on an existing query( Qry1). I would like the data from my query (Qry1) to be displayed in the record (in Form1) which I am viewing. When I go onto a new record (IN Form1) I would like to make a new selection from my query (Qry1) and then store these details in the new record in Form1.

I am a little frustrated - please help.

 

[quest4]

Not to hard to do, in the Got Focus event of the control add:
Me.YourControlName.Requery
If you don't want to store the results of the query, use a unbound control. hth.

 

[PST]

I am not sure how to set a control. I have reposted my thread. Please do not respond to this thread. Thanks.