Workbook Queries

[sameer_mehta]

Hi,

I have a requirement to create workbook which will contain 2 queries. Both the queries have same selection criteria i.e. records are filtered based on Customer ID. For this I have designed a custom pop up through which user can enter customer id. Now the requirement is pop up must be displayed once for both the queries and the records get filtered in both the queries.

I have desgined one query and it is working fine but dont know how to satisfy the filter criteria with one pop up for both the queries.

Thanks in advance.

[Former Member · Accepted solution]

Hi,

We canu2019t merge two queries variable pop up screen as one. Each query is having its own variable pop up screen. As you have added two queries in one workbook, then if you refresh it will display one by one variable pop up screen.

You said you have created custom pop up does it means have you written any macros??

Hope it helps you.

Thanks

Riyez

[sameer_mehta · Accepted solution]

Thanks for your reply.

Both the queries have common pop up. So it is useless to display same pop up again. The requirement is the value entered by the user should go to both the queries.

[sameer_mehta · Accepted solution]

Also I am using SAP functionality for the pop up. I have written the code for pop up in user exit under i_step = 1.