Multiple search criteria

[melaniews]

The basic setup of the database is that a customer has bought a product and filled out a card listing what other things they might be interested in.

The marketing dept wants to pull a report of names and addresses of people interested in various other products.

There are about 20 possible values for this field. I want the user to be able to select radio buttons with the specific values they want from this field -- Multiple values. (ex: chickens or ducks or geese)

I have created a form that has radio buttons -- one for each value in the field -- and the output report.

I do not know how to connect these radio buttons to the values -- I've done it before but am drawing a blank today.

Then, how do I capture these values when "true" and put them in as the criteria for the query to populate the report?

Also, if I'm approaching this incorrectly, please let me know a better way. I'm trying to make it as simple as possible for the user.

TIA
Melanie

 

[deulyd]

First of all, (If I'm understanding everything) you should not use radio buttons when the user can select multiple instances... you should use check box instead; it's just a matter of standards.

For the rest of your problem... I'm pretty sure I could help you but I'm not sure I understand it. What do you mean by "connect therese radio buttons to the values"? It look more like a form problem than a report problem.

Deulyd

 

[melaniews]

Thanks for the response. I was wondering if I was going to get one. Sometimes I don't ask questions very well in these forums.

I see your point on the check boxes. I'll keep that in mind. However, I've changed my setup and am now using a list box.

I suppose you are right about the forum also.

Thanks again,
Melanie