How to run a query from a control on a form

**flsticks** · 05-05-2011, 03:08 PM

I have a database being used by several locations. I built a table called SITES and made a query which selects the site names. I made a form call Site_Frm, which uses a combo box listing the sites from the site query. I now want to run all my other queries based on the form Site_Frm. My query entry is this: [Forms]![SITE_Frm]![SITEcombo]. I put that in the criteria of a query asking for employee information. All my tables have controls named SITE. Problem is the query is not taking the information from the Site_Frm. Any ideas?

**alansidman** · 05-05-2011, 03:24 PM

This may help you.

http://www.datapigtechnologies.com/f...earchform.html

Alan

**jzwp11** · 05-13-2011, 05:58 AM

Could you provide an example of one of the queries? Is the query returning results but not the results that you expected? Would you be able to provide more info on your table structure?

How to run a query from a control on a form

Thread Tools

How to run a query from a control on a form

Similar Threads

Filter data on a form from another control on the same form

Open Form But Don't Run Query Referenced in Control Source

Using A Cal Control On A Form

Control sourced from another control will not update field in table

using form's control as criteria in a query

Posting Permissions