I have a combo box set up, and I would like a separate, smaller form to pop up for info depending on the choice they select in the combo box. For example, if they choose "Visitor", I have a form for visitor address and form that I'd like to pop up. Then whatever info they enter in this 2nd form would be stored in the main table. Is this a subform? I kind of thought a subform was always visible and just set into the main form. Not sure how to start this. Thanks in advance for any help you can give me!
Well I figured that part out!! Now I have a new question regarding the same issue:
I have a form and just figured out how to get a pop-up form to open if a certain answer is entered into a field. But so far I've only had one option per field that needed a pop-up form.
I now have a field (combo box) called OccurrenceCategory that the user can pick from one of several options.
If they answer "A", I want the "A" form to pop up. If they answer "B", I want the "B" form to pop up. Etc.
I have all the pop-up forms created and ready to go, I just need help with the macro. I tried putting several OpenForm commands, each with a different where statement for each different answer, but it opens all possible pop-up forms no matter which answer you choose. I also tried entering it into the Condition column in the macro, but I got a visual basic error when I tried to test it.