Hi,
I have a form that has query as row source. Query is:
SELECT [rm] & " - " & region AS Expr1, Zrepregion, RMquery.RM, RMquery.Region, RMQuery.Zrepreg ion, * FROM RMquery WHERE (((RMquery.BU)=[forms]![ExpiringContrac tsInputForm]![bu]) AND ((RMquery.ba) Like [forms]![ExpiringContrac tsInputForm]![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?
I have a form that has query as row source. Query is:
SELECT [rm] & " - " & region AS Expr1, Zrepregion, RMquery.RM, RMquery.Region, RMQuery.Zrepreg ion, * FROM RMquery WHERE (((RMquery.BU)=[forms]![ExpiringContrac tsInputForm]![bu]) AND ((RMquery.ba) Like [forms]![ExpiringContrac tsInputForm]![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?