Form that runs queries based on depressed (not sad) buttons

D

Derek Wittman

I have a simple database (4 real tables) that I would like
to create a query on. My goal is this - to create a form
that, when options (buttons?) are selected, these options
are considered for criteria. When the GO button is
clicked, the criteria are used in either OR or AND,
depending on the need of the user. Basically, I want this
to be a seamless approach for Joe User to be able to run
queries without having to set them up.

For example, Joe can depress a Candy button, and a
Selection button, then click GO and the "desc" field in
the 'behind-the-scenes' query will be

(Like *Candy* or Like *Repack*)and Like *Selection*

If I understand correctly, I need to pass the criteria
through a Macro, which will execute the query WITH the
criteria selected. Can someone help? (I have NO VBA
programming, but a little SQL)
 
G

Guest

I realize I am replying to my own post. Rather than button presses, I've elected option (radio) buttons for my selections within an option group. So, I want to run a query based on the option button pressed determining the query critera (including wildcards as mentioned below). I hope this adds to the clarification, and not the opposite.

Thank you!


----- Derek Wittman wrote: -----

I have a simple database (4 real tables) that I would like
to create a query on. My goal is this - to create a form
that, when options (buttons?) are selected, these options
are considered for criteria. When the GO button is
clicked, the criteria are used in either OR or AND,
depending on the need of the user. Basically, I want this
to be a seamless approach for Joe User to be able to run
queries without having to set them up.

For example, Joe can depress a Candy button, and a
Selection button, then click GO and the "desc" field in
the 'behind-the-scenes' query will be

(Like *Candy* or Like *Repack*)and Like *Selection*

If I understand correctly, I need to pass the criteria
through a Macro, which will execute the query WITH the
criteria selected. Can someone help? (I have NO VBA
programming, but a little SQL)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a macro to run a query with criteria entered into a form 1
Using Option Buttons to Modify a Query 1
from that runs a query 1
Running a Query with multiple criteria 1
Set criteria for multiple queries entered in one dialog form? 1
Set Query Criteria from Form 6
Should I re-create criteria using form filter of just use the relevant query as recordsource? 2
Using a list box and combo boxes as criteria for a query 2

Top