FORM HELP PLEASE!!!

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

Guest

Hi,

I am not sure if this could be done or not but. I have made changes to my
table and it does not reflect the changes on my form. For example. I have
changed the state for Las Vegas, NY to Las Vegas, NV and it will not update
the items that are on the form unless I reselect the state again and click on
them all. Does someone know if there is an easier way?

Thanks
Helpless
 
If you want to change everything that is Las Vegas, NY to Las Vegas, Nv,
write a update query that will change the entries in your table.
 
I am sorry, I am fairly new to Access , would I create a query with the old
information or the new, or both?

Thanks again for your prompt response
 
Create a new query.
Select the table with the values you want to change.
Make it an Update Query
Select the field you want to update. You may need to select both city and
state if they are different fields.
In the Update to row for the state enter NV
In the Update to row for the city enter Las Vegas
In the criteria row for the state enter NY
In the criteria row for the city enter Las Vegas
Run the query.

I would suggest you make a copy of your table in case you have a problem and
need to go back to the original.
 
Thanks for you help! :)

Klatuu said:
Create a new query.
Select the table with the values you want to change.
Make it an Update Query
Select the field you want to update. You may need to select both city and
state if they are different fields.
In the Update to row for the state enter NV
In the Update to row for the city enter Las Vegas
In the criteria row for the state enter NY
In the criteria row for the city enter Las Vegas
Run the query.

I would suggest you make a copy of your table in case you have a problem and
need to go back to the original.
Click to expand...
 
Back
Top