Narrowing Data Input Options

[Nctukek92]

This may or may not be a very basic question as I am almost completely inexperienced with Access (I do learn rather quickly however), so bear with me. I am trying to create a database that will narrow the potential inputs you can have as you submit the data. For example; in field one I will have a column titled "Types of Food", in which the user will be able to select from "Fruits, Vegetables, and Meats". The next field will be "Raw Ingredients". I want to make it so that if the user inputs "Fruits" into the first fields the second field will only present the options "Apples, Oranges, and Pears", and so on.



Any advice is helpful, simplicity is appreciated!

[June7]

That is dependent or cascading comboboxes. Review http://datapigtechnologies.com/flash...combobox2.html

[Estuardo]

G'd morning,
Here is another example (much better in my opinion) from PBaldy, one of our moderators http://www.baldyweb.com/CascadingCombo.htm
G'd luck

[Nctukek92]

Hey guys, thanks for the feedback! Both examples were very helpful, I'm currently working on using what you gave me to create something closer to what I need. Thanks for the head start!

EDIT: Question - For the second example, how could I make the form create a new line every time I fill it out? For example; Say I picked CA and Los Angeles, how can I get that to save in the database and create a new row that I could then input more information by filling out the same form?

[June7]

Maybe a button Click event to save new record and the refresh the combobox.

0ne way to save record with date, text, number examples.

CurrentDb.Execute "INSERT INTO tablename(field1, field2, field2) VALUES(#" & Me.textbox1 & "#, '" & Me.textbox2 & "', " & Me.textbox3)