Validate form on previouse box

G

Guest

I am setting up a form for Purchase Orders. I have a categories, supplier,
and supply table. I want the supplier to be dependant on the category box
and the supply to be dependant on the supplier selected based on my tables.
I have a similar design in excel, but access will work much better due to
reports and tracking orders.

ie. if select "boxes' as a category, I don't want "bag suppliers" to be an
option.

Thank you
 
J

Jeff Boyce

Tim

Check into "Cascading Comboboxes" via Google.com and/or mvps.org.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

filter query on combo box in a continuous subform 0
Update combo box after new entry 4
Text box un-editable on form 5
Using vlookup to populate multiple rows at once 5
Order entry form using data from a second table 5
Cancel Event Procedure on Button if Combo Box is Empty 3
ComboBox results on form show as a number in report 1
Droplist/Combo box 4

Top