Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ComboBox/NotInList Question

Status
Not open for further replies.

metrodub

Technical User
Dec 29, 2004
82
US
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.
 
Why not just add 'PO Waiting' to the combobox using the method here:
How do I add an <All> selection to my combo box drop-down?
faq702-4538
[ponder]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top