Hey,
I've been searching already quiet some time to do the following :
I want to open a somehow same report for 3 different locations. The location is chosen from a selection list on a form.
I have the following code behind my "show report"-button
Docmd.openreport "total sales & me!sellocation",...
where me!sellocation is the selection list on my form.
The issue I have is that everything between "..." is interpreted as text, and the variable is not read.
I also tried something like ""total sales " & "me!sellocation"", but then only "total sales " is read.
I was wondering if anyone knows if I can use variables at all using the docmd.openreport.
Regards,
Peter
I've been searching already quiet some time to do the following :
I want to open a somehow same report for 3 different locations. The location is chosen from a selection list on a form.
I have the following code behind my "show report"-button
Docmd.openreport "total sales & me!sellocation",...
where me!sellocation is the selection list on my form.
The issue I have is that everything between "..." is interpreted as text, and the variable is not read.
I also tried something like ""total sales " & "me!sellocation"", but then only "total sales " is read.
I was wondering if anyone knows if I can use variables at all using the docmd.openreport.
Regards,
Peter