using form to pass multiple criteria

  • Thread starter Thread starter Lee Stafford via AccessMonster.com
  • Start date Start date
L

Lee Stafford via AccessMonster.com

I have an unbound report that asks for the Month, System, and Tech ID. If
I wanted the report to display two different tech IDs, how could I go about
that? I currently have the parameter set to display all Tech IDs if there
is no data input. Say I want it to display Jan, Feb, & Mar for Tech's
66105 and 66107? Is this possible?

Thanks,
Lee S.
 
I take it, that your report is based on a query, that looks at a text box
(or drop down combo) on your form. Something like;
=[Forms]![frmName]![txtName]
Unfortunately, you can't do;
IN ([Forms]![frmName]![txtName])
Which would be ideal, as you could type in a comma delimited list of tech
id's. Therefore, what you may have to do, either update a temporary table
with the tech id's that you want and in your query criteria use an 'exists'
clause. Otherwise, you can programmatically edit your query before opening
it.
 
I haven't heard of the exists clause, but I will check it out for future
use. I have to make the report process as easy as possible since I will
not be the primary end user. So, I don't think I could update the
temporary table.

I have never actually programmed using VBA or VB. I have adjusted other
snippets of code that someone else had used, but never programmed anything
myself. So, I guess that isn't an option either. Unless someone could
give an example of what I could use.

Thanks for your suggestions,

Lee S.
 
Back
Top