Limit to list

[Rolls]

Been a while since I did this & can't remember how.

tblInvoice
InvoiceID PK
VendorID FK
AddressID FK
etc.

tblVendor
VendorID PK
VendorName
etc.

tblAddress
AddressID PK
AddressLine1
AddressLine2
City
State
Country
Zipcode

frmMain contains cboVendor and cboAddress. What I want to do is to be able
to set up a new invoice, select a VendorName using cboVendor, then select an
address from one of the available addresses for the vendor selected by
cboVendor using cboAddress. tblInvoice will save the Vendor and Address
selected. I can't remember how to code the forms Access 2000.

 

[Daniel]

You want to base one combo box on the value of another. take a look at the
microsoft tutorial

http://office.microsoft.com/en-us/access/HA011730581033.aspx

Daniel