changing the captions on labels

[Guest]

just starting out in access and need help !!!!!
I have made a DB that many sites will use (siteA),(SiteB)
each site has a diffrent site Name, address, cityStateZip and address
what i've done is made a Macro using setvalue. it works fine
when you enter information into the fields it changes the proper label
but when I close the form and reopen it later all the labels have returned
to the
old values.
how do you get them to stay put untill such time that you need to change
them later

any help would be great Thanks

 

[Douglas J. Steele]

If you're in a multi-user environment, you can't. That's because to change
them permanently would require that you save the design change to the form,
and you can't do that in a multi-user environment.

If you're in a single-user environment, you could save the form to capture
the changes, but I really think it makes more sense to change them
dynamically each time you open the form, to ensure that you've got the
correct captions.

 

[Ron2006]

Are/is this application split between data and forms? It is advisable
that it is.

Will it be running on a network?