combo box problem

[John thomas]

Hi I use a combo box to select products and place in my order details sub form .I now realise i need a catogories table .how can i get my combo to look up a categories table then go the products of that table then enter in my orderdetails.
Please keep it simple i am a newbee

 

[bob fitz]

Not sure that I understand, but if you mean that you want to restrict the items shown in the Products combo box by first selecting a Category, then these are often called "Cascading Combo Boxes". See: http://www.baldyweb.com/CascadingCombo.htm
There is also an example DB that you can download there.