Updte an unbound Combo from a query

[avtuvy]

I have the following scenario:
1. A form which is bound to a query (Query1)
2. Several txt boxes which are bound to fields in the query (Query1)
3. Several combo boxes which get a list of values from another query (Query2) and a default value from Query1

When I click on the arrows at the bottom of the form to move to the next record all of the values in the text boxes get updated but the values in the combo boxes do not get updated. The combo boxes are not bound. I am loking for a way to update the combo boxes as I go through the records.

 

[DCrake]

You need to set the bound colukn in the combo to the foreign key in the main query. Then set the control source to the field in the query. The combo can be bound but he rowsource can be unbound.

 

[avtuvy]

I am a little bit confused, I am working with two queries, Query1 is the main quey which has the forign key. Do I need to set the "Default Value" property of the combo box to the forign key in the main query and the "Control Source" property to the field in the query?

 

[avtuvy]

I was able to do what you suggested and the data in the combo box does change but since it is bound to the lookup table (Query2) it updates the lookup table, how do I prevent that update?