LINK COMBO BOX PICK TO A FORM

[mdavis1]

I HAVE A FORM THAT HAS 3 SYNCHRONIZED COMBO BOXES, YOU CAN SELECT 1) CUSTOMER 2) LOCATION 3) CATEGORY. AFTER YOU PICK THE CUSTOMER, IT FILTERS ONLY LOCATIONS FOR THAT CUSTOMER, AND AFTER U PICK LOCATION, IT ONLY SHOWS CATEGORIES FOR THE CUSTOMER AT THAT LOCATION. AFTER U SELECT THE CATEGORY, I WANT A FORM TO OPEN WITH THE INFORMATION FOR WHAT U HAVE CHOSEN. THAT'S WHAT I'M HAVING TROUBLE WITH. I CAN'T FIGURE OUT HOW TO GET THE FORM TO OPEN WITH THE FILTERED INFORMATION..ANY HELP WOULD BE GREATLY APPRECIATED. THANKS IN ADVANCE.

 

[nickjar2]

Design a form based on a query. In the query add some criteria

ie. Customer field
criteria forms!formName!comboname

do the same for the other 2 fields

This way you have query that will display record(s) that are for the customer. loc and category.

Nick

 

[nickjar2]

And then in the after_Update of the category combo box you could first check whether all combos are filled in, then:

docmd.openform "formName"

Nick