Thread: DoCmd
View Single Post
Old 11-14-2019, 04:30 AM   #4
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,765
Thanks: 454
Thanked 902 Times in 866 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: DoCmd

Code:
DoCmd.OpenReport "rptCurrentSale", acPreview, , "[ContractID]=" & Me.ContractID  & " And  [sellerID] = " & Me.txtSellerID
FWIW I tend to put filter/where criteria into a string and then use that.?

That way I can debug.print it.

HTH
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is online now   Reply With Quote