Adding a Field to an existing Form

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

Guest

I added a new field to an existing table but when I go to add that field to
an existing form using field list it isn't an option.
 
Pat said:
I added a new field to an existing table but when I go to add that
field to an existing form using field list it isn't an option.
Click to expand...

Is the form based on the table or maybe a query?
 
It has every field in the table except the new one so I assumed it was based
 
If the form's based on a query, as it really should be, you need to go into
Design View for the query and add the new field to the grid.
 
Look at the form's Record Source property in the Properties dialog box. If
it looks like SQL, rather than a table name, click on the ellipsis (...) to
the right of the property.
 
Is there a properties or something for the form that I can find which Query
is it based on?
 
Douglas You are my MVP Thanks so much that is exactly the info I needed
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access How to remove a non-existent field from a form's Field List 0
How to add an additional field in the existing database table 5
Adding a new field to a form in Access 2002 3
Access Create option group without using wizard? 2
Check if a date exists in a record 1
Problem with errror 3341 6
Form field list 2
AutoNumber Field Broken: How To Fix? 9

Back
Top