Adding New Field Names To Field List

[Guest]

Form previously had phone number in a field with free-form entry. Now user
wants to standardize phone number into Access format, which will prohibit
things like extention, other comments, etc. I tried to add another field for
extentions and comments. I can do so in the tables, but these fields do not
show up in form design mode when I ask to view the field list.

How do I add the new fields to the field list so I can added it to the form
and have the data be recognized and shown on the form that had been placed in
the table's field?

Earl Phillips
Ex-mainframer trying to Access
To help the local food bank

 

[Kevin K. Sullivan]

It sounds like your form may be based on a query, rather than directly
on the table that you've changed. Check the recordsource property of
the form to make sure. If it is a query, you'll need to modify the
query to include the new table fields.

HTH,

Kevin

 

[Guest]

You were right, it was based on a query. However, the field list for the
query does not include the new fields, so I cannot add the fields into the
query. Any suggestions on how to add the fields to the query? The new fields
do not even show up in the Query Wizard.

Earl Phillips
Frustrated Ex-Mainframer trying to do Access

 

[Armen Stein]

You were right, it was based on a query. However, the field list for the
query does not include the new fields, so I cannot add the fields into the
query. Any suggestions on how to add the fields to the query? The new fields
do not even show up in the Query Wizard.

Earl Phillips
Frustrated Ex-Mainframer trying to do Access

That's a strange problem.

Open the table and make sure that the new fields are there. Enter some
sample data in them. Close the table.

Create a brand new query based on that table. I don't know how many
tables you have, but make sure you're looking at the same exact table.
The new fields should show in the drop down list of fields in the query.

If you still can't see them, maybe your database is corrupted. I
haven't seen this behavior with a corrupted database, but just in case,
back up your database, and Compact and Repair it (under Tools - Database
Utilities).

Beyond that, I'm not sure what else to try.

 

[bob]

If that does not work, try creating a new empty access database and import
your objects

Bob

 

[Armen Stein]

If that does not work, try creating a new empty access database and import
your objects

Yes, good idea, and easy to try. But when we've seen corruption, it has
usually involved weirdness with VBA code or bad memo fields. I don't
recall ever seeing fields in a table structure not showing up in queries
and forms.

 

[Guest]

All tables are linked ones, which apparently was the key. I re-linked the
main table involved, deleted the old version of the linked table and its'
relationships, recreated the relationships in the newly linked table and
added the new fields to the query for the main form (the table was named
tblMain, appropriately). Then I had the new fields available on the field
list for the form and in the query wizard.

I thank everyone for their suggestions as it pointed me in the right
direction. I just thought you all would like to know what the solution was
in case something similar presents itself to you.

Earl Phillips
Ex mainframer, now less confused about Access