If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update a an unbound combo box
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. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201003/1 |
#2
|
|||
|
|||
Update a an unbound combo box
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 |
Thread Tools | |
Display Modes | |
|
|