Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Save Changes in Form Design w/o Using Design View

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I was wondering if there was a way to save the changes in a form's design (labels) by using VBA code?
I'm setting up a database that tracks job progress, but for each job, I have to enter the description of each item at the beginning. Since the jobs last for months and the descriptions and items stay the same, I made a setup form that stores the descriptions as public variables. Then I have the form that I want the descriptions displayed on call the public variables as captions for labels.
I want to prompt the user to save if the labels have changed. Is it possible? Thanks.
 
Someone said that I could store the values in a table and have the label captions call the values. Does anyone know how I would write the code to call certain values in a table field? Thank you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top