Goof up......

A

Annette

My company uses access to keep track of all shipping records. Somehow three
of the states where changed from the list. How can I get them changed back to
their original letters? Example:AL is now MD. When I try to change it back,
the message says that it is not on the list and that I am to pick only from
that list.
 
R

Rick B

Where is the list geting it's data from? Do you have a table where you
maintain the list of states and their abreviations? If so, go to that table
and fix it.
 
R

Rick B

In design view, look at that field's properties and see what ROW SOURCE and
ROW SOURCE TYPE settings are.
 
A

Annette

The ROW SOURCE TYPE is: Table/Query and the ROW SOURCE is: SELECT SHIP_STATE.
How do I get into there to change it? I appreciate all your help, thank you
very much!
 
R

Rick B

Click on the elipse button to the right of ROW SOURCE. You should open a
query. The table it is using should be in the top half of the screen. Note
it.

Close the query and the form.

Open the query or table that you noted in the last step and fix it.
 
A

Annette

OK, now I'm feeling REALLY stupid...or just overwhelmed at the moment. I
found the table but don't know how I access it to make changes.
 
R

Rick B

Open your database window (if it is hidden, try pressing F11), click the
Tables tab, double-click the table.
 
A

Annette

WHEW!! You saved me! I definately need to take a course on this because none
of my co-workers know anything either. THANK YOU!!
 
Top