Need help with a type of report

[access1234]

I have in my input form a field that contains a down arrow with about 20 location names where I have projects (ex: Florida, New York, France, UK….and so on). I want to create a report based on a location (to see all the projects for that location) but I don’t want to type it rather to see the same down arrow this way I can pick it from the list before the reports is run.


Please note I am not an expert but have some OK knowledge of access.
Anyone can help?
THANKS

[pbaldy]

You can create a report that returns all locations, then use this technique to restrict it to the selected item:

BaldyWeb wherecondition

[access1234]

Thanks dbaldy but I am not sure what you mean. In other reports I have, for example, if I want to run a report based on range of dates, before the repost runs, it ask me to enter the first and then the last date. Basecaly I want to do a similar thing where it will ask me for the location but instead of me typing it, I would like to pull it from my preset list of that field.
I am not sure If I am making myself clear. Any idea?
Thanks

[pbaldy]

You're using bracketed criteria, like [Enter start date]? If so, you can't get a list. The only way to get a list is to use a form for the user to enter criteria. In that scenario, instead of the above criteria you have this in your query (changing the names):

Forms!FormName.txtStartDate

or you can use the technique in the link.

[access1234]

Thanks for your help so far. I think I am getting to understand your first theory with a second fgorm. My question (and this is because I am not an expert) where do I place this: DoCmd.OpenForm "SecondFormName", , , "FieldName = '" & Me.ControlName & "'"
Thanks

[pbaldy]

That is VBA code. It would often be in the click event of a button. If you've never used VBA before:

http://www.baldyweb.com/FirstVBA.htm

[access1234]

Dbaldy, Thank you for all your help. My database works FINE thanks to you.

[pbaldy]

No problem, happy to help. Welcome to the site by the way!