Adding field to field list after the fact

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form I've created and I need to add a field that I've added to one
of the tables I'm using in the forms, but I don't know how to add the new
field to the field list that already exists in the form I've created. I'm
hoping there's a way to do this because it took me awhile to get the form the
way I wanted it and I'd hate to have to redo it from scratch. I've just
started working with Access so you could say I'm a complete novice. The form
uses tabs and it took me quite awhile to get them the way I needed them to be
so as I said I hope there's a way to just add the field to the field list and
then add it to the form. Any help would be greatly appreciated.

Thanks
 
You don't have to have the field list. Create the control on the form for
the field, then opent thep properties dialong box. Use the drop down in the
control source property to select the new field.
 
WCDoan said:
I have a form I've created and I need to add a field that I've added
to one of the tables I'm using in the forms, but I don't know how to
add the new field to the field list that already exists in the form
I've created. I'm hoping there's a way to do this because it took me
awhile to get the form the way I wanted it and I'd hate to have to
redo it from scratch. I've just started working with Access so you
could say I'm a complete novice. The form uses tabs and it took me
quite awhile to get them the way I needed them to be so as I said I
hope there's a way to just add the field to the field list and then
add it to the form. Any help would be greatly appreciated.

Thanks
Click to expand...

If the new field doesn't show up automatically in your field list it's
because your form is not bound directly to the table but rather a query or
SQL statement that is explicitly naming the fields you chose during the form
wizard. You will need to edit the query/SQL so it includes your new field.
Just click the [...] button to the right of the RecordSource property for
your form and that will open the query designer where you can add the field
in.
 
Back
Top