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

DlookUp - Multiple conditions

P: 1

I have a form that has query as row source. Query is:

SELECT [rm] & " - " & region AS Expr1, Zrepregion, RMquery.RM, RMquery.Region, RMQuery.Zrepregion, * FROM RMquery WHERE (((RMquery.BU)=[forms]![ExpiringContractsInputForm]![bu]) AND (( Like [forms]![ExpiringContractsInputForm]![BA]));

I want to store the value of Zrepregion in a listbox so that I can use it for running the final report.

Now I can do this in 2 ways:

1. I get the value of Zrepregion from this row source but since I'm hiding this column, I'm not sure what function to use.

2. I get the value of rm and region from expression "rm-region" in the row source. Now using these 2 values I get the value of "Zrepregion" from "RMQuery". But I'm not sure how to do this.

Can someone please help?
Sep 10 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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