SQL statement in Access resubmit a form to itself?

[Guest]

I'm trying to design a form in Access so that when click on an option in a
drop-down menu, that will prompt the form to bring up another drop-down menu
with additional choices for selection. For example, if the menu said "Fruit,
Vegetables, Dairy" and you clicked "Fruit", the current drop-down menu would
be replaced with one that said "Apples, Oranges, Pears" and you would select
one. I was told that in the Form Design View I would have to enter an SQL
statement that would resubmit the form to itself. Any ideas on what that
statement should be? Also, I'm really not that familar with Access so please
be clear in your reply. Thank-you so much!

 

[Guest]

I'm trying to design a form in Access so that when click on an option in a
drop-down menu, that will prompt the form to bring up another drop-down menu
with additional choices for selection. For example, if the menu said "Fruit,
Vegetables, Dairy" and you clicked "Fruit", the current drop-down menu would
be replaced with one that said "Apples, Oranges, Pears" and you would select
one. I was told that in the Form Design View I would have to enter an SQL
statement that would resubmit the form to itself. Any ideas on what that
statement should be? Also, I'm really not that familar with Access so please
be clear in your reply. Thank-you so much!

What you are talking about is called (sometimes) "Cascading Combo Boxes".
Look at:

http://rogersaccesslibrary.com/download3.asp?SampleName=CascadingComboBoxes.mdb

or

http://www.mvps.org/access/forms/frm0028.htm

for examples on how to set them up.