populating combo box

  • Thread starter Thread starter Kreplech
  • Start date Start date
K

Kreplech

i have two tables - vendor & account (joined by fk)

i have two combo boxes on a form - vendor & account

i'd like to be able to pick a vendor and have the account combo narrow down
choices according to which accounts apply to each vendor

this possible?

your help is aapreciated in advance.

-mark
 
i have two tables - vendor & account (joined by fk)

i have two combo boxes on a form - vendor & account

i'd like to be able to pick a vendor and have the account combo narrow down
choices according to which accounts apply to each vendor

this possible?

your help is aapreciated in advance.

-mark
Click to expand...

Leave the Row Source of the Account combo blank.
Set it's Row Source Type to Table/Query

In the AfterUpdate event of the Vendor Combo:

[AccountCombo].RowSource = "Select [FieldName] from tblAccount Where
[VendorID] = " & [VendorCombo] & " Order By [FieldName];"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box Question 2
Duplicates in union query 3
Access Help 0
Criteria in Query/Form 1
Combo Box 1
AUTO POPULATE subform from combo box selection 1
Populating Combo Box from table based on selection - QUESTION 4
combo box query within a subform 1

Back
Top