Henley12
Troy University Fan
- Local time
- Today, 07:30
- Joined
- Oct 10, 2007
- Messages
- 222
I have an odd situation. I am trying to program a combo box to select two different sets of criteria depending on the value in a text box on the form. For example, when I open up the form, it is pulling in a Manufacturer name from another form based on the Equipment ID. But if the equipment id is 'miscellaneous', the newly opened form field will have 'misc' in the text box. If the text box has 'misc', I want the combo box to display all choices from the underlying query. If the text box has the name of a manufacturer, I want it to only display those records in the combo box. I hope this makes sense.