adding fields to an existing form

[KevinS]

I have a form that took me a lot of time to get right and now I have to add
more fields to it.

The fields come from an external linked database. Do I have to recreate the
form or can I somehow add the additional fields. The only fields that show
up in the field list are the ones currently associated with the form. Unlike
a query where you can add a table or Query; forms doesn't allow that.
Thank you!

 

[John W. Vinson]

I have a form that took me a lot of time to get right and now I have to add
more fields to it.

The fields come from an external linked database. Do I have to recreate the
form or can I somehow add the additional fields. The only fields that show
up in the field list are the ones currently associated with the form. Unlike
a query where you can add a table or Query; forms doesn't allow that.
Thank you!

A Form has a Recordsource property... which *can* be changed. Normally this
would be a Query. Are the fields in the current form based on a local table?
Is that table related somehow to the external linked database? Can you create
a Query joining the local table to the linked table?

Once you have a Query containing the fields that you need, you can set the
form's Recordsource property to that query, and the new fields will become
available. Remember that a Form does not have fields - it has Controls
(textboxes, combos, etc.) which can be bound to fields.