I have a form for Projects. On this form are 11 controls:
cboProjectCompany - Unbound combobox with Company Names.
cboPONumber - Bound (POID) combobox that contains Purchase Order Numbers associated with the Company chosen from the Company combobox.
cboPOExist - Bound (POExist) combobox questioning whether a PO Number exists for the company.
What I would like to happen is this...
If a project comes up and a Company is used without an existing PO Number, the user would select 'No' from cboPOExist. At this point, I would like cboPONumber's value to be 'POWaiting' or something similar so that the funds will still be associated with the company (Currently, most companies only have one PO Number, but some have more than one. The projects are tied to the PO Number, which in turn are tied to the companies.)
How would I go about coding the AfterUpdate event of cboPOExist so that 'POWaiting' becomes cboPONumber's (a text field) value?
Thanks in advance.
cboProjectCompany - Unbound combobox with Company Names.
cboPONumber - Bound (POID) combobox that contains Purchase Order Numbers associated with the Company chosen from the Company combobox.
cboPOExist - Bound (POExist) combobox questioning whether a PO Number exists for the company.
What I would like to happen is this...
If a project comes up and a Company is used without an existing PO Number, the user would select 'No' from cboPOExist. At this point, I would like cboPONumber's value to be 'POWaiting' or something similar so that the funds will still be associated with the company (Currently, most companies only have one PO Number, but some have more than one. The projects are tied to the PO Number, which in turn are tied to the companies.)
How would I go about coding the AfterUpdate event of cboPOExist so that 'POWaiting' becomes cboPONumber's (a text field) value?
Thanks in advance.