Change Record Source of a Form - Twist

[SteveM]

Old problem - new twist. I created a Split Form using a query as the
record source. I want to change the source to a permanent table that
has the same field names as the query result.

However, after I changed the Record Source in the Form's Property
Sheet and viewed the Form, there was no Table content in the Form's
data fields or data grid.

Any help on what I am doing wrong?

Thanks,

SteveM

 

[Chegu Tom]

Steve

Use the build button next to the rccord source (three dots)

Use the query builder to select your new table and fields.

 

[SteveM]

Steve

Use the build button next to the rccord source (three dots)

Use the query builder to select your new table and fields.

Tom,

Thanks, but that didn't work. The Form was built from a query that
uses a data table call "AllData". However, I can not edit the
underlying AllData table in the Form. So I want to embed the AllData
table directly in the form. Redefining the AllData table as the
source presents an empty View Form. I then took your suggestion and
rebuilt the query by just using the AllData table in the query
designer and selecting all the fields that map to the field names of
the Form. That did not work either.

Of course I can rebuild the Form from scratch, but I'd like to figure
this out for future work.

Any other ideas would be appreciated.

Thanks again,

SteveM