run query-urgent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following queries

select customer_name from customer where city = "Chicago";\
select vandor_name from vendor where city = "Chicago"

I would like to use a form to let the user decide which
city and then run both the queries

How do I do so?

Thanks
 
create a new unbound form. put a combo box on the new
form. Then in your SQL statement type,
SELECT VENDOR_NAME FROM VENDOR WHERE CITY = [forms]![name
of your form]![name of the combo box]
You can use the same combo box for both queries or use two
separate ones. Put two control buttons on the form that
are set to run each query. You can either type "Chicago"
in the combo box or allow the user to select it from a
predefined list of cities you have created. post back if
you need clarification on anything. matt.
 
Matt

Thanks for your response. Can I use one button to run
both queries?

Thanks
-----Original Message-----
create a new unbound form. put a combo box on the new
form. Then in your SQL statement type,
SELECT VENDOR_NAME FROM VENDOR WHERE CITY = [forms]![name
of your form]![name of the combo box]
You can use the same combo box for both queries or use two
separate ones. Put two control buttons on the form that
are set to run each query. You can either type "Chicago"
in the combo box or allow the user to select it from a
predefined list of cities you have created. post back if
you need clarification on anything. matt.

-----Original Message-----
I have the following queries

select customer_name from customer where city = "Chicago";\
select vandor_name from vendor where city = "Chicago"

I would like to use a form to let the user decide which
city and then run both the queries

How do I do so?

Thanks
.
Click to expand...
.
Click to expand...
 
Yes. Just create a macro that runs both queries. Then
set the button to run the macro.
-----Original Message-----
Matt

Thanks for your response. Can I use one button to run
both queries?

Thanks
-----Original Message-----
create a new unbound form. put a combo box on the new
form. Then in your SQL statement type,
SELECT VENDOR_NAME FROM VENDOR WHERE CITY = [forms]! [name
of your form]![name of the combo box]
You can use the same combo box for both queries or use two
separate ones. Put two control buttons on the form that
are set to run each query. You can either type "Chicago"
in the combo box or allow the user to select it from a
predefined list of cities you have created. post back if
you need clarification on anything. matt.

-----Original Message-----
I have the following queries

select customer_name from customer where city = "Chicago";\
select vandor_name from vendor where city = "Chicago"

I would like to use a form to let the user decide which
city and then run both the queries

How do I do so?

Thanks
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
thanks matt.
-----Original Message-----
Yes. Just create a macro that runs both queries. Then
set the button to run the macro.
-----Original Message-----
Matt

Thanks for your response. Can I use one button to run
both queries?

Thanks
-----Original Message-----
create a new unbound form. put a combo box on the new
form. Then in your SQL statement type,
SELECT VENDOR_NAME FROM VENDOR WHERE CITY = [forms]! [name
of your form]![name of the combo box]
You can use the same combo box for both queries or use two
separate ones. Put two control buttons on the form that
are set to run each query. You can either type "Chicago"
in the combo box or allow the user to select it from a
predefined list of cities you have created. post back if
you need clarification on anything. matt.


-----Original Message-----
I have the following queries

select customer_name from customer where city
= "Chicago";\
select vandor_name from vendor where city = "Chicago"

I would like to use a form to let the user decide which
city and then run both the queries

How do I do so?

Thanks
.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top