B
Box666
Using Access 2003, I have created an unbound form that has a drop down
select box on it.. There are just 4 selections available from the
dropdown box. At the bottom of the form is a button that will update
all relating records.
What I would like to happen is if "choice1" is selected in the
drop down box then when they press the update button it will run
"query1", if they have selected "choice2" from the dropdown box
then "query2" will automatically run and the same with
"choice3" -it will run "query3" etc.
I believe I may need to run a conditional macro, I have tried to look
this up in the help file but have not been able to understand how it
should work.
Can anyone give assistance please.
With thanks
Bob
select box on it.. There are just 4 selections available from the
dropdown box. At the bottom of the form is a button that will update
all relating records.
What I would like to happen is if "choice1" is selected in the
drop down box then when they press the update button it will run
"query1", if they have selected "choice2" from the dropdown box
then "query2" will automatically run and the same with
"choice3" -it will run "query3" etc.
I believe I may need to run a conditional macro, I have tried to look
this up in the help file but have not been able to understand how it
should work.
Can anyone give assistance please.
With thanks
Bob