[AccessD] problem with DoCmd.OpenReport

Stuart McLachlan stuart at lexacorp.com.pg
Thu Feb 5 15:58:40 CST 2004


On 5 Feb 2004 at 22:46, Pedro Janssen wrote:

> strExp = "[code] =" & Me![Code]
> stDocName = "EtiketqryDymo"
> DoCmd.OpenReport, acViewPreview, , strExp
> 
> End sub
> 
> When i use this i get an error:
> Syntax error (operator missing).
> 
> How is this possible, i used this code many times before with forms.
> 

You forgot to tell it which report to open <g> :

DoCmd.OpenReport stDocName, acViewPreview, , strExp 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.





More information about the AccessD mailing list