Advanced Beginner
Windows XP 
Access 2003
I've looked all over the forum and can't seem to find a similiar soultion anywhere. I am trying to open a report "Current" where "Type" is equal to Small or Medium. The code I've entered is:
DoCmd.OpenReport "Current", acViewPreview, , [Type] = 'Small' Or [Type] = 'Medium' but I haven't had much success. Please help
Who is John Galt?
Windows XP Access 2007
The wherecondition is a string argument. Try
DoCmd.OpenReport "Current", acViewPreview, , "[Type] = 'Small' Or [Type] = 'Medium'"
Master of Nothing
Windows 2K Access 2000
BE aware that "Current" and "Type" are reserved words in Access and shouldn't be used as object names.
See: http://allenbrowne.com/AppIssueBadWord.html
Last edited by ssanfu; 05-31-2012 at 02:45 PM. Reason: computer can't spell
Open (sub)form linking 2 criteria on current form
Posting Permissions
Reply With Quote