2 drop down lists on a form

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

Can someone tell me how to link two drop down lists so
that if you pick one item from the first drop down list it
populates the second. I am using two tables. First table
has the product. Second table has the flavors. Both
tables have a product ID that links them. The flavor
table has extra 2 digits to recognize flavors. How do I
use the Product ID to link the drop downs?

I'm pretty comfortable with using the Control Source, List
Row Source, List Bound and List Display field. I do not
understand what or where I go to put the two together.

Any help would be greatly appreciated.

Thank you.
 
Can someone tell me how to link two drop down lists so
that if you pick one item from the first drop down list it
populates the second. I am using two tables. First table
has the product. Second table has the flavors. Both
tables have a product ID that links them. The flavor
table has extra 2 digits to recognize flavors. How do I
use the Product ID to link the drop downs?

I'm pretty comfortable with using the Control Source, List
Row Source, List Bound and List Display field. I do not
understand what or where I go to put the two together.

Any help would be greatly appreciated.

Thank you.
Click to expand...

You can download a sample database at www.Bullschmidt.com/Access and open it up
and notice that on the Invoices Dialog the Customer combo box on the search
form is based on what was entered in the Rep combo box above it.

This is done by the RowSource property of the Customer combo box's SQL
statement. Also the OnEnter property of the Customer combo box runs a function
which requeries itself:

' Dim var.
Dim ctl As Control

' Set var.
Set ctl = Screen.ActiveControl

' Requery control.
ctl.Requery

Best regards,
J. Paul Schmidt, Freelance Access and ASP Developer
www.Bullschmidt.com/Access - Sample Access Database
www.Bullschmidt.com/login.asp - Web Database Demo
 
Hi Kim -

This is Steven from Microsoft Access Technical Support replying to your
newsgroup post.

A step-by-step process for synchronizing combo boxes on an Access form can
be found on the following web page:

Four ways to move to a record from a Combo Box selection
http://support.microsoft.com/default.aspx?scid=KB;EN-US;287658

Please let me know if this solves your problem or if you would like further
assistance. I look forward to hearing from you.

Sincerely,
Steven Parsons [MSFT]
Microsoft Access Product Support Services
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! (http://www.microsoft.com/security)
 
Back
Top