How do I add a new field to a form after the form is created?

  • Thread starter Thread starter CCB
  • Start date Start date
C

CCB

I created tables then a form in Access 2003.

Then I needed to add a couple more fields to my tables, and I want to put
them on my form.

The field names don't show up in the Field List box in design view of my
form. How do I get them to show up?
 
CCB,
After you've added the new fields to your table, you'll need to go back
to the RecordsSource query behind the form and add those new fields to the
query grid (or your SQL statement). Then they will appear on you Field
List.
hth
Al Camp
 
Al's answer will work if it is a query your form is bound to. If you are
bound directly to the table, then all you need to do is create a new text
box, then you can drop down the available fields in the control source
property.
 
Back
Top