Zydeceltico
Registered User.
- Local time
- Today, 08:19
- Joined
- Dec 5, 2017
- Messages
- 843
Hi All -
I have a form where I record inspection data.
One of the bound controls is a combo box with several options in it. In most cases, the user would make a selection in the cbo and when the form is closed the chosen value will be stored in the underlying table.
There is one potential selection - that if chosen by the user - I would like for another form to immediately open - right then on AfterUpdate of the cbo - or when the cbo loses focus. The user would then fill out a couple of details to be stored in a different table, hit a Save button, and return the original form and complete the rest of the data input fields.
How can I tell the cbo that if the user chooses this specific option from your list of options then open the second form without closing the first form keeping the first form open so the user can return to it after filling out the second form?
Thanks,
Tim
I have a form where I record inspection data.
One of the bound controls is a combo box with several options in it. In most cases, the user would make a selection in the cbo and when the form is closed the chosen value will be stored in the underlying table.
There is one potential selection - that if chosen by the user - I would like for another form to immediately open - right then on AfterUpdate of the cbo - or when the cbo loses focus. The user would then fill out a couple of details to be stored in a different table, hit a Save button, and return the original form and complete the rest of the data input fields.
How can I tell the cbo that if the user chooses this specific option from your list of options then open the second form without closing the first form keeping the first form open so the user can return to it after filling out the second form?
Thanks,
Tim