from that runs a query

  • Thread starter Thread starter ryan.fitzpatrick3
  • Start date Start date
R

ryan.fitzpatrick3

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?
 
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?
Click to expand...


Try removing the form's RecordSource property. Then when
you figure out the criteria, set the RecordSource to the SQL
statement.
 
Back
Top