How do I bound a query to a form?

If it's an existing form, look at the form's properties (make sure it's the
properties of the form, not of a control or section on the form) and change
the RecordSource property to the name of the query.

If it's a new form, when you're creating the form, select the query from the
list of tables and queries.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"ajwittman" <(E-Mail Removed)> wrote in message
news:2CB6A82D-4FCC-4A0C-8D67-(E-Mail Removed)...
> How do I bound a query to a form?

If it's a new form, use the form wizaed to create a form, and in the stage
when yo need to select a table, select the query you want, that way the form
will be created bounded to the query.

If you want to use the query in existing form, open the form in design view,
open the form properties, one of the properties call RecordSource, locate the
cursor in it, on the right you'll see a button with three dots and a button
(combo like) that will display a list with all the tables and select queries
that you have, select the desired query.

--
Good Luck
BS"D


"ajwittman" wrote:

> How do I bound a query to a form?