Star Taylor said:
How do I create a user input query so it can be added on the switchboard?
I need to create a way for a user to input/select specific parms, press a
button, then alacazam! Their query appears! (If you can't tell, the user's
are unfamilar w/Access so it has to be easy for them.)
I'll be adding this to the current switchboard.
Thanks for any help!
Star Taylor,
Design a new Form, I'll call it frmForm1 here, with whatever labels
and text boxes are needed for the user to enter specific parameters.
It'll probably be using a Default View of Single Form. (You can use
the Form Wizard to make adding the labels and text boxes very easy.)
Design a second new form (using Single Form or Datasheet View, as you
prefer), I'll call it frmForm2 here. Have the Record Source of
frmForm2 be your new search Query, I'll call that Query1 here.
Put an OK button on frmForm1 and add the "frmForm2" the buttons On
Click event (property page, event tab).
Have Query1's SQL or QBE Grid refer to the text boxes on frmForm1 in
order to achieve the output results you are looking for when Query1 is
executed.
When the OK button on frmForm1 is clicked, it should launch frmForm2,
which should appear using Query1's results, which will be using the
user's inputted information on frmForm1, and the data on frmForm2
should be what the users are looking for.
Add a button to the switchboard that launches frmForm1.
Sincerely,
Chris O.
