Forms

[Humberto]

I'm new to Access 2002, (migrating from Lotus Approach)
and I think this may be an easy question for most of you.

I created a form using the forms wizard and I selected
the databases and fields I needed to create the form,
very straight forward and easy to do. I have since added
new fields to a couple of the databases I used to create
the form and cannot find a way to insert these two new
fields in the form. Any help will be greatly appreciated.

Thanks

 

[fredg]

I'm new to Access 2002, (migrating from Lotus Approach)
and I think this may be an easy question for most of you.

I created a form using the forms wizard and I selected
the databases and fields I needed to create the form,
very straight forward and easy to do. I have since added
new fields to a couple of the databases I used to create
the form and cannot find a way to insert these two new
fields in the form. Any help will be greatly appreciated.

Thanks

If the table the fields are in is the recordsource of the form, then, in
Design view, click on the Field List tool button and drag the field onto
the form.
However, if a Query is the form's record source, then first add the new
fields to the query.
Then they'll be available in the Field List to be dragged onto the form.

 

[humberto]

Fred,
Thanks for the reply. I did not use a query as the record
source, I just selected the fields I needed directly from
the databases. It does sound that a query was the way to
go. Would you suggest to always create a query for every
form I create?

Thanks again for your reply.

Humberto