Adding field in table; then field not showing up in form

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

Guest

Hello all..

Wondering if any of you can help me out. I have several tables that I'm using to build a form. I'm in the process of building the form and realize that I need an additional field. I go back to the table in question and add the field. However, once I go back to the form and list all of the fields available, the field does not show up. HELP ME PLEASE :

Paul
 
Paul Reynolds said:
Hello all...

Wondering if any of you can help me out. I have several tables that I'm
using to build a form. I'm in the process of building the form and realize
that I need an additional field. I go back to the table in question and
add the field. However, once I go back to the form and list all of the
fields available, the field does not show up. HELP ME PLEASE :)

Your form is likely not bound directly to the table, but rather is using a
SQL statement or query. In either of those cases you can use two different
kinds of SQL statements.

SELECT * FROM SomeTable...

or

SELECT Field1, Field2, Field3... FROM SomeTable...

The former will automatically pick up any new fields that are added to the
table. The latter will not so you would have to modify the SQL either to
use the SELECT * strategy or to explicitly include the new field you added.

This would be in the RecordSource property of the form.
 
Back
Top