Filtering what appears in a Form using a Query

[David Ball]

Hi,
If I have a continuous form, based on a table, can I have the records displayed in the form controlled by a query?
I have a query that returns the ID numbers of records that I need to edit. I would like to have the form show only those records so that I can edit them easily
If the control source of the form is the table how would I link the query info to the form?
I am so confused by record sources and control sources in Access…

Thanks very much
Dave

 

[Minty]

Use the query as your control source for the form, make sure the query has all the fields you need on your form.

 

[mjdemaris]

You could easily select the Table, click create Query, customize it as you so desire, then close it. Select the query in the nav pane, and click create more forms --> multiple items.
Then take a look at the record and control source properties and you have your form, too.

 

[jdraw]

Look at this article and related code from Allen Browne and see if it applies to what you are trying to do.

Why a continuous form?