Adding field to existing table

[skydiver]

Help! I'm nervous about doing this only because I am a self taught MS Access novice so be nice. I'm using MS Access 2003. I've created a nifty database for our office and it works like a charm. I'm trying to add another field (same type as others) to my main table, however when I attempt to add the field to my form via the field list...it does not appear. If this has anything to do with creating an updated query...I'm not familiar with this. Please help. Thank you.

 

[boblarson]

First off let me say that, if a database has been properly designed, it is RARE to have to add fields to a table. So, my question to you is - what is this field, what datatype is it and what are the other fields that are like it?

 

[skydiver]

Thank you for the prompt response. We recently added a new category for this particular data, hence the reason for adding it after the fact. It is a "Number" data type along with many others of equal type.

 

[boblarson]

New Category makes it sound like it isn't properly normalized, sorry to say. You should be able to add a ROW of data to a table to add that.

 

[skydiver]

I was able to add the new Field Name in the main table, but could not find it on my field list when trying to add it to the existing form.

 

[boblarson]

What version of Access? Is your form using the table for its record source, a query or a select statement?

 

[skydiver]

Access 2003. Regarding my form...yes, I used the main table for my form.

 

[boblarson]

Access 2003. Regarding my form...yes, I used the main table for my form.

The field should show up in the field list right away (if you remembered to save the table).

 

[skydiver]

Bob "The Man" Larson...here to save the day!!!!!!!!!!!!!!!!!!!! Got it! I forgot the form was based on a query, thus not showing up on my field list because I had only updated the main table, not the actual query. You put me on the right track Bob! Can I buy you a coke???