Update a an unbound combo box

[avtuvy via AccessMonster.com]

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.

 

[ghetto_banjo]

On the form's On Current event (which runs when focus changes from one
record to another), put in this code:

Me.MyComboBox.Requery



That will update a combo box