editing multiple pages at one time

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

Guest

Using access professional 2003 I made a form that shows information on
different cities. Each page within the form shows one zip code within the
city. I would like to know how to select all the pages (all zipcodes) for
one city so I can modify the info for that particular city. i.e I have 48
pages for zipcodes in Orlando. I need to add the name for the manager in
Orlando on all 48 pages at once, and the manager always changes so I will
need to do this often.

Please help me.

Also what are macros?
 
Without having all the information on how your database is structured, I will
assume the form's record source is a table and that zip code, city and
manager are fields on the form that are contained in the underlying table.
You could put a button at the side of the managers box labelled update all.
when clicked enter something like this in the code

DoCmd.RunSQL "UPDATE YourTable SET Manager = '" & Me.Manager & "' WHERE City
= '" & me.City & "'"

You may need to do some checks to make sure a manager has been typed in and
a city exists etc.
 
Back
Top