Adding Record Source

[Guest]

Hi,

I created a form and now I find I would like to add an additional record
source table. How is that done? Thanks

 

[fredg]

Hi,

I created a form and now I find I would like to add an additional record
source table. How is that done? Thanks

If your form's recordsource requires more than one table, you will
need to create a query that combines the tables. Use that query as the
form's record source.
Be aware that some queries are not updateable.

See the Access Help Answer wizard:
When can I update data from a query?
+ Data can't be updated

 

[Scott McDaniel]

I created a form and now I find I would like to add an additional record
source table. How is that done? Thanks

You'd need to build a query that provides the needed data, then base your form on that query. If you open the form in
Design view and click the Build button to the right of the Recordsource box, Access will launch the query designe, and
you can build your query from there (note: this won't store the query where you can edit it, so if you need it for other
things you might want to build your query first, then base your form on it after).

Note however that basing a form on a query can cause some unwanted results IF your query isn't updateable so take care
when building the query. In my experience, most forms are based on a single table with Subforms used to show Child
records.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Aaron Kempf]

yes.. the unpredictable 'is my query going to be updatable' is one reason I
stopped using MDB

with SQL Server it's 100 % reliable and dependable

You'd need to build a query that provides the needed data, then base your

form on that query. If you open the form in

Design view and click the Build button to the right of the Recordsource

box, Access will launch the query designe, and

you can build your query from there (note: this won't store the query

where you can edit it, so if you need it for other

things you might want to build your query first, then base your form on it after).

Note however that basing a form on a query can cause some unwanted results

IF your query isn't updateable so take care

when building the query. In my experience, most forms are based on a

single table with Subforms used to show Child