How to : OpenArg

[phoenicks7]

Is there a way (other than using Global Variables) to pass multiple OpenArgs to a subsequent form?

For instance.... we have 3 different shifts listed (1,2,3) at my workplace... and when a supervisor runs a report from the startup form, would need to pass a date AND the shift number to the resulting form.

i.e.,

DoCmd.OpenForm "Performance Stats",,,,,OpenArgs:dteDate=txtStartDate : intShift=txtShift, etc, etc.

 

[ShaneMan]

Hey phoenicks7,

Yes, you could pass multiple OpenArgs but would also have to separate out those OpenArgs at the called report/form, but with that being said, unless I'm over looking something, it looks like your trying to do a couple criteria's to open the report and if that's right then I would like to ask why you wouldn't do that in your WhereCondition of the OpenReport? If you did that there then I think you would accomplish what your looking for. Hope I followed your question.

HTH,
Shane