Forms - adding a query as a data source in an existing form

[Newby]

An easy Sunday morner.


I am trying to add a query in an existing form. When I click on adding a field, I get an option to show "all tables" for not queries.

Stumped

Newby

[June7]

True, nothing to be done about that. Why are you clicking on adding a field to 'add a query'? What are you really trying to accomplish.

[Newby]

[QUOTE=June7;149245]True, nothing to be done about that. Why are you clicking on adding a field to 'add a query'? What are you really trying to accomplish.[/QUOTE

When you set up a form, you have the option to select a table or query, but you are not able to modify a form to add a query? It doesn't sound right. It feel like i am missing a trick.

[June7]

A form's RecordSource can be an Access table or query object or an SQL statement. RecordSource is a property of form and can be modified. Setting RecordSource has nothing to do with the 'add a field' popup.