Add New Field to Form

K

Karen

I have a DB I use for tracking records for training employees. Our training
document numbers have changed, so I added a field in the table with the new
document numbers. The fields consist of Old number, new number, title &
date. There is another table with employee names and another table with all
of the fields from the two mentioned tables that we use for data entry.
Using all these fields from both tables, a form was created. Now I want to
add the new field on my form with the new numbers. When I click "Design
View" in my data entry table, and then click "Field List", the field I need
is not listed. How do I go about getting this new field into my form? I
hope I have given you enough info to solve this. If not, let me know
Thank you, Karen
 
D

dan artuso

Hi Karen,
What is the record source for your form?
You can find this out in the Form's properties sheet on the Data tab.
It sounds like your using a query for the record source in which case you
have to add the
new field to your query.
 
K

Karen

Thank you for your help - I created a new query and used that for my record
source. Now, I cannot create a new record in my form. My "new record"
button is grayed out.
Do you know what I did wrong?
Thank you
 
D

Dan Artuso

Hi,
I can't tell you specifically what you did wrong but somehow you have made
the query not updateable.
Now, I don't think simply adding a new field would do that unless you used
any of the aggregates,
SUM, MIN, MAX and so on. Perhaps you should post your SQL.
I'm off to work now and then will not be online again until Tuesday, so
hopefully some can
continue to help you.

Dan Artuso, MVP
 
Top