Filtering Forms

  • Thread starter Thread starter Nick.Korynski
  • Start date Start date
N

Nick.Korynski

Hi, I have a form with a subform of more detailed information. I have 4
fields on my main form that are in a separate table where each of these
fields is a sort of subset of the data above it. For example, the top
level would be like the customer category, the next level would be the
customer name, and below that is the product for that customer. I want
to be able to filter the combo boxes so that when I choose the customer
category, then only customer names appear in the next combo box that
match the chosen category. I also am going to apply this to the levels
below as well. Is there any way to do this in access without VB or is
VB needed? Thanks. Any help would be appreciated.
 
Nick,

Sorry for the "bad news". To do what you want you have to use VBA as you
need to change the properties of your combo according to the filter that
your are using. You also need VBA to change the filter, for that matter.

Regards/JK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

1)VB code or Wizard? 2) Subform or filter? 3)combo box problem 5
Filter suggestions in form 4
Sync Main Form with Subform after Combo Selection 2
Multipule Filter on a Form 11
Filter a form using a combo box and a macro 2
Trying to filter a form by VBA 1
Filter subform somehow! 6
SQL "IF" Question 5

Back
Top