How to prompt for criteria

[kavarin]

I beleive I have an idea on how to do this, but I want to get some valued opinions first-

I want to generate a report based on a speciic value that the user is prompted for, then have an underlying query pull all the records that match that value and generate the desired report. Should I create a macro that simply prompts a user for the appropriate value, then generates a query on that entry? Or is there another way to do this?
Example:
User is looking for all customers that have bought property within a specific community. These communities are listed in a separate table for lookup purposes. I want the report to show me all property purchased in "XYZ" community (and all the assoiciated fields that the query pulls).
Does this make sense?

 

[David R]

There are a couple of ways to do this.
http://www.access-programmers.co.uk/ubb/Forum5/HTML/002713.html is about inputting date ranges, but you can modify it for Text fields, partial fields, etc.

HTH,
David R

 

[kavarin]

Thanks David-
I beleive that is the post I used to generate my criteria, and I posted you regarding a follow up on this matter. I can get it to work using this criteria IF THE USER KNOWS THE APPROPRIATE VALUE. I am hoping (and silently praying) that there is a way to have the prompt supply the same drop-down menu that the users have in the data-entry form I created. Do you know of a way?

 

[David R]

Yep. Check the other posting (I think in Forms forum).

David R