Assinging a value to a drop-down box

J

Joseph Greenberg

I have a drop-down box which is populated at form load by a query from a
look-up table in the database (the query captures a number and the
corresponding text, and only the text is shown). How can I programatically
(from a button click) tell the combo box to "now pick this selection from
the list", based on the text value? So there are 15 distinct (and only 15)
possible values - say flavors. If there is a database value for that field
it will pick it up for the combo box. But if there isn't, I want to click a
button that says "assign this one the value of Chocolate" (or whatever
flavor is appropriate based on other criteria).
 

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

Link a text box based on drop down box with four options MS Word 365 0
Drop down list control value in vba 2
Clearing combo boxes and a text box 2
How to make repeating drop-down lists? 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Combo or list box 0
Auto populate value from one task to another in MS PROJECT 0

Top