Change the record source of a form

[Bob Quintal]

How can I change the record source of my form from the current
table to a new query so that I don't lose all the codes and
settings on the form and only have to edit them if need be.

Open the form in design view.
Open, if necessary, the properties popup.
click in the recordsource box on the data tab.
Click on the elipsis (...) to the right of the box
Answer yes to the message box that asks if you wish to create a
query.

Build the new query.

 

[injanib via AccessMonster.com]

How can I change the record source of my form from the current table to a new
query so that I don't lose all the codes and settings on the form and only
have to edit them if need be.

 

[Jeff Boyce]

First, make a backup of the .mdb file.

Open the form in design view. Click in the square box in the upper left
corner.

Click the Properties button. Pick the new source.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

How can I change the record source of my form from the current table to a new
query so that I don't lose all the codes and settings on the form and only
have to edit them if need be.

Open the form in design view. View its Properties. Select a new value for the
Recordsource.

None of your controls or their properties will be harmed.

The only concern is that the new recordsource should have fields corresponding
to the Control Sources of all the controls on the form; otherwise you'll get
errors. You can get around this by defining aliases for fields in the query,
or adding new fields defined as "" if there are controls on the form that
don't have any corresponding data in the new recordsource.

John W. Vinson [MVP]

 

[injanib via AccessMonster.com]

Thanks.That will work. My other source is simply the query of the old table
and another table. All field will have the same names.

 

[Rob Parker]

In the property sheet for the form itself (you can select it by clicking on
the black dot in the upper-left corner, at the intersection of the rulers),
on the Data tab, simply enter the name of the query in the Record Source
field. If the query has the same field names as the table, you won't have
to change anything else; if the field names are different, you will have to
change things where appropriate.

HTH,

Rob