By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Using where condition in access macro

P: 1
I have a shipping form that has a print preview button. I would for it to bring up the current record. In the macro I have tried ="[lpallets shipped].[shipping list]=" & [Shipping List] it works pulls all records with the current Shipping list Number. I have also tried with ="[lpallets shipped].[Job Number]=" & [Job Number] and it pulls all the shipping lists under that job number. What I would like to do is combine them so that it pulls the current Job Order and only the current Shipping List. If I add the "and" between the causes it call all the shipping lists.
Feb 26 '19 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 3,182

Welcome to Bytes!

Your syntax should look like this:

"[lpallets shipped].[shipping list]=" & [Shipping List] & " AND [lpallets shipped].[Job Number]=" & [Job Number]

Hope this hepps!
Feb 27 '19 #2

Post your reply

Sign in to post your reply or Sign up for a free account.