I have a form that has a combo box that queries its contents from a table. If a user were to type in something other than what's inside the combobox list, is there a way to automatically update the table. So that I would not have to type the record inside the look-up table manually. Hopefully this makes sense...but if anyone could help, this would be greatfully appreciated..Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combo Box based on a look up table query
- Thread starter merv805
- Start date
judgehopkins
Technical User
On your form set the limit to list property to no.
Here's the way you do that. Open the form you are working on in design view. Right click on the combo box you want to change. Click the data tab. Under limit to list, set it to no.
Judge Hopkins
There are only two rules for success: (1) Never tell everything you know.
Here's the way you do that. Open the form you are working on in design view. Right click on the combo box you want to change. Click the data tab. Under limit to list, set it to no.
Judge Hopkins
There are only two rules for success: (1) Never tell everything you know.
- Status
Similar threads
