Combo Box help

J

jonkeu

Hey. I have a form that im using as a transaction log

However I have one combo box that i want to sort based on the mai
categories

I have 4 main cats and about 5 products per cat. Rather then having
drop downs is it possible to have it list the main cats then say a lin
and then the products below the main cat? and they can only choose th
products to get a required result so bascily the inside of the comb
box would look like this


MAINCAT1
---------
PROD 1
PROD 2
PROD 3

MAINCAT2
---------
PROD 4
PROD 5
PROD 6


ETC..

any help let me know
 

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

Filtering Combo #2 from a value in Combo #1 6
Nested JOIN clauses - order of precedence (Access 2007) 2
Count/Sum rows of a column depending on criteria from drop-down li 4
Extracting top performing products by region 3
update combo box 8
Form box pulling 2 data items 2
newbie needs help simple form 2
seeking solution to synchronize two combo boxes on a subform 16

Top