×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Using 2 Combo Boxes on a Form

Using 2 Combo Boxes on a Form

Using 2 Combo Boxes on a Form

(OP)
I am using 2 tables,T_Supplier and T_Product joined as a query,Q_SupplyProd.On a form I have 2 Unbound Combo boxes, one is Supplier, two is Product, the Form name is FM_Supply. When I select a Supplier from the first combo box (Supply), I only require the products provided from that supplier to appear in the second combo box, (Prod). I am using the query, Q_SupplyProd for the input for the combo boxes. I have used the following SQL statement in RowSource in Prod combo box,
SELECT DISTINCTROW Q_SupplyProd.Supplier, Q_SupplyProd.Product
FROM Q_SupplyProd
WHERE (((Q_SupplyProd.product)=[Forms]![FM_Supply]![supply])));
I select the Supplier from the first combo box (supply), then click on the second combo box (prod), a window opens requesting “Enter Parameter Value” I type in a supplier click OK, nothing appears in the drop down list of the products combo box. Even typing nothing in the window, there is no dropdown list from products when I know that supplier has this product, there appears to be no reference to the first combo box.
There is also code in the AfterUpdate on the first combo box as follows -
Private Sub Productcheck_AfterUpdate()
Supply.Requery
End Sub
I would be grateful for any assistance.
kevsim

RE: Using 2 Combo Boxes on a Form

Send me an email. I have an example db. Just check the Sample selection form.

John A. Gilman
gms@uslink.net

RE: Using 2 Combo Boxes on a Form

(OP)
jagilman,
Thank you for your assistance.
kevsim

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close