Filtering Using Combo Boxes

[Beanie_d83]

Hi all,

I am trying to apply a filter on selection of a field in a combo box so that a second combo box will only display records relating to the first selection.



The first combo box needs to list the names of the companies who sell our products (first table) and then a second combo box list only the locations of each store owned by that company (second table). This information will then be stored in a third table.

Hopefully this all makes sense and I will be thankful for any help given!

[orange]

The subject involved is Cascading Comboboxes

There are many links and youtube videos on the subject.

good luck

[Beanie_d83]

Hi there,

thanks for the tips I have managed to successfully achieve what I wanted to with the combo boxes and all works well except now when I populate the first combo box, my auto number no longer increments to a new record. Any pointers?

[orange]

How does a combobox on a form interact with your autonumber assignment??

Hopefully this is not a lookup field in a table...

Need more info

[Beanie_d83]

From that question I'm assuming then it shouldn't interact with it? It isn't a lookup field, but a query as from what I've read is the better way in which to do things.

What I simply need it to do is to generate a new record when the first combo box is selected but for some reason I just could not get this to work properly!