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];"
 
Back
Top