Multiple Queries for one form?

C

Carlee

Hi there,

Is is possible to programically switch queries for a form? The purpose of doing this would be so that i can drill down viewable data based on what a user selects from a list box.

How can i do this or can i even?
 
W

William Taylor

use the after update event of the listbox to change the recordsource
property of the form:
me.recordsource = "NewQuery", the property is a string value. then use
me.refresh to see the changed data.
Carlee said:
Hi there,

Is is possible to programically switch queries for a form? The purpose of
Click to expand...
doing this would be so that i can drill down viewable data based on what a
user selects from a list box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crating User Form to Add Names 1
Link a text box based on drop down box with four options MS Word 365 0
How to make repeating drop-down lists? 2
Excel does not accept text format! 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Weekly Report 2
Tracked changes by multiple people modified to one 0
Embed the same Excel multiple times 0

Top