Combo Boxes

J

JL

Since you alread have a multi-cloumn combo box.
You can trigger an "After Update" event to fill in all the
form fields that can be fill in with the combo box.

After Update event:
sub fields_After_Update ()
..
..
..

me![Field1onForm] = me![combobox].column(0)
me![Field2onForm] = me![combobox].column(1)

..
..
..
end sub

Note: The first column in the combo box is 0.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box 0
Combo or list box 0
Combo box columns 1
VBA Coding Help for Beginner 0
Making a macro only work on certain files 2
Code to populate combo box 1
Run query to feed combo box 2
Assign query results to combo box 1

Top