ryan.fitzpatrick3[ at ]safeway.com wrote:
[Quoted Text] >I created a from where I would like to run a query on criteria that
>provide. the criteria are a selection of comboboxes where a user can
>select whatever. the first problem is that when I open the form out of
>design view it automatically wants to connect to the database server
>prompting our password right away, which I do not want to happen. How
>should I do to make it where I can select all the criteria and then
>push a button to run the query and the results in the criteria show
>up. What I'm stuck on is how to not have the form automatically
>connect to the database server and how do I get the criteria in the
>comboboxes in that query?
Try removing the form's RecordSource property. Then when
you figure out the criteria, set the RecordSource to the SQL
statement.
--
Marsh
MVP [MS Access]
|