Combos and Queries

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I am using Microsoft XP.

On a form I have put a combo box that list company numbers
and names, tblCoNbrs. The user selects a company and then
selects an account from another combo box. The account
list is dependent on which company is selected.

The Row Spurce for the account combo is a query listing
all of the accounts available and the company that account
belongs to, tblAcctList. Now when the user selects a
company the correct account list is available in the
account combo box. I've done this by putting in the
criteria line in the query the value of the combo box for
the company selection.

The problem I am having is if the user initially selected
the wrong company. When this happens, the account combo
list the account list for the originally selected company.
If the company is changed, the account list seems to be
controled by the original company selection. The only way
I have found around this is to create a button that closes
and then reopens the form.

How can I get the query on the account combo bos to use
the current value of the company combo box and not the
original entry?

I appreciate any and all help.

Thanks

Ken
 
Ken said:
I am using Microsoft XP.

On a form I have put a combo box that list company numbers
and names, tblCoNbrs. The user selects a company and then
selects an account from another combo box. The account
list is dependent on which company is selected.

The Row Spurce for the account combo is a query listing
all of the accounts available and the company that account
belongs to, tblAcctList. Now when the user selects a
company the correct account list is available in the
account combo box. I've done this by putting in the
criteria line in the query the value of the combo box for
the company selection.

The problem I am having is if the user initially selected
the wrong company. When this happens, the account combo
list the account list for the originally selected company.
If the company is changed, the account list seems to be
controled by the original company selection. The only way
I have found around this is to create a button that closes
and then reopens the form.

How can I get the query on the account combo bos to use
the current value of the company combo box and not the
original entry?

I appreciate any and all help.
Click to expand...

In the AfterUpdate event of the first ComboBox you need a line of code that
does a Requery of the second ComboBox. Similar to...

Me.SecondComboBoxName.Requery
 
Back
Top