have a window pop up based on a value supplied in a lookup on a form
Posted on 2014-01-27
I have a form in ACcess that the user selects a value, if the user selects a specific value from a combobox I would like a message box to appear asking the user to supply an Invoice Number. Then want that invoice number to be stored in the record source of the form.
the combo box is combo42, the value they would select to cause the Message Boxo to be displayed would be "MCMC"
FIeld in the record source would be "MCMCINVOICENO"