Populating unbound control on form open

[metrodub]

I have a project form (frmProjects) that contains an unbound control. This control (cboProjectCompany) has a list of vendors/companies. A second dropdown (cboPONumber) contains account numbers associated with the chosen company. This control is bound to the project table, but the vendor/company is not.

I have another form used to search/update projects. When you choose the project from the dropdown in this form, the project form opens with all of the entered data with the exception of the vendor/company name and the account number. The account number does not show up as it is associated with the company. When you re-select the vendor/company, the correct account number shows.

Is there a way to get the correct vendor/company to show, even though the control is unbound?

 

[Pampers]

hi metrodub

maybe something like this

link the two boxes in CurrentEvent (OnCurrent) for the form
where you want this to happen; like:
cboBox1 = txtText1


Pampers.

You're never too young to learn

 

[metrodub]

Didn't work. As cboPONumber is dependent on the unbound control (cboProjectCompany), when the form is opened cboPONumber (for some reason) is empty as well.

 

[Pampers]

if the cbopon depends on cbopc, and cbopc is an unbound control - thus empty on opening - so wil cbopon. so make sure cbopon has its source set to the the table. Once cbopon is populated (from the table), so wil the cbopc; it will synchronise with cbopon
also make sure that the ControlNames are correct


Pampers.

You're never too young to learn

 

[metrodub]

The control source for cboPONumber is already set to POID in tblPO.

Where else should a source be set?