Toggle Button

[JoelSaltzman]

I have a huge list of inventory. it is split up into 8 categories. so i made a table for each category. I want to use a combo box to choose the iventory item that i am selecting but i do not want to have 8 different combo boxes. How can i use toggle buttons or check boxes or something of the sort to choose which table the combo box uses.

 

[dgm]

You could probably do it that way by having the toggle button/check boxes change the row source of the combo box to match the corresponding tables.

But i think you would be better off leaving it all in one table and using your toggle button to filter the combo box by category...


Dave

 

[JoelSaltzman]

how?

Im a newbie at this. I use filemaker normally so it is much easier. Would you mind explaining it either way.

 

[dgm]

Best way would probably be to use two combo boxes.

Have a look at this thread http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=31900&highlight=cascade+combo
or try doing a search for 'cascading combo boxes'...
plenty of them on here