Query In A Form

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

I am trying to run a query in an access form, but the
query does not show up under the Control Source --> Query
portion of the field I am trying to run it in. I have
the query written and it shows up under the Query heading
on the main switchboard, but it does not show up under
the query subheading in the control source.

Thanks
Ben
 
Hi Ben,
The only place you can assign a query is for the Record Source of a form.
Each control on the form can then have a Control Source corresponding to
one of the fields in the form's Record Source (the query).

HTH
Dan Artuso, MVP
 
You must log in or register to reply here.

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

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Form Query 1
Query/subquery in form 1
Main Form and two Subforms 2
Display Data In Form From A Query 1
Which is faster? 6
Form controls invisible when underlying query returns no rows 1
Show totals on Switchboard? 4

Back
Top