maverick235
New member
- Local time
- Today, 13:40
- Joined
- Dec 27, 2019
- Messages
- 11
Hi All,
So here's the situation:
So here's the situation:
- I've already launched a database with front and back end that allows users to add/edit records for their tests. One of the fields is what equipment they need. Initially I had only left it as select one equipment.
- Now I've got request to add ability to select multiple values within "Equipment Needed" field.
- I've done this in the past, where I had made it a combobox for the field. And this combobox was connected to the "Data" table and one of the fields in the data table was "Equipment Needed" that pulled the list (lookup wizard, multiple values allowed) from a "Equipment" table.
- This made the combo box field on the form have the ability to "check mark" the different equipment and hit the "OK" button.
- I've done this in the past, where I had made it a combobox for the field. And this combobox was connected to the "Data" table and one of the fields in the data table was "Equipment Needed" that pulled the list (lookup wizard, multiple values allowed) from a "Equipment" table.
- With this previous knowledge, I decided to update the new database with this ability by replicating exactly what was done before (as described in the 2 indents above).
- I made the appropriate changes on the "Data" table (changed the "Equipment Needed" field from short/text to lookup wizard and allow multiple values etc.
- I converted the list box on the Form to a combobox accordingly
- Now the combobox works:
- When you hit the drop down, the list comes up and you can "check off" as many equipment you need.
- However, nothing gets updated when you hit "OK". In fact, after hitting "OK" nothing happens, the combobox drop down doesn't roll back up (as it used to previously). I feel like I'm missing something real simple here.