Update a combo box field on a form

[myseven123]

I created a combo box field for Vendor Information on a form. The data is
pulled from a table with two data types and appears in the form as a combo
box. How can I update the table from the form? Is it possible and/or is there
a better way to do this?

 

[Jeanette Cunningham]

Hi myseven123,
one easy way is to put a label saying 'Edit vendor' next to the combo box.
Make the text blue and underlined.
When the user clicks the label, you open the form to edit the vendor details
(at the same id of the record selected in the combo, if they selected
something) in dialog mode.
When the user closes the vendor edit form, you can requery the combo.
If you want, you can grab the id for the edited record from the vendor edit
form and use that to set your combo to the same id.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[myseven123]

Thank you...I had done something like this in another db but used a button
instead of a label to access the table.

 

[myseven123]

Jeanette, My Access skills are limited so I need a few more details. Am I
right in saying that after I create the label I need to create a Macro for
the on click event inorder to open the form with the vendor details? And if
so what does that event/code look like???

 

[Jeanette Cunningham]

You could do the same thing with a button instead of a label. If you use a
button, the wizard can do the code to open the vendor form.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia