Select a Value (text format) from a combo box in an update query

[Guest]

How do I utilize a combo box to select a value for the update value in an update query?

 

[Michel Walsh]

Hi,


In the query, make a reference to a form combo box control:
FORMS!FormName!ControlName.


Start the form. FIll the combo box. In the after update event of the
combo box control, have VBA code that start the query, with DoCmd ( or that
otherwise recuperate the combo box selection). Definitively YOUR CODE start
the query AFTER having displayed the combo box, but if you instructed the
end user to open the form to start the process, for that end user, the
experience is "as if" the query was prompting for a parameter in a combo
box.


Hoping it may help,
Vanderghast, Access MVP

How do I utilize a combo box to select a value for the update value in an

update query?