How to Create Template that changes Labels

[Guest_imported]

I was wondering if there was a way to have a setup form that stores variables for certain items in the database and then assigns those values to corresponding labels or text boxes in other forms and reports.

For example, I have a setup form that contains the decription, total quantity allowed, and unit price of certain items (1-40). I have another form that is based on a table that lists those items under a certain date. Each day I want to enter the current quantity in a field, but I want the description, total quantity allowed, and unit price to be displayed also. Since these things all stay constant throughout the life of the job, I can't just declare them as public variables because I lose the values when the database is closed. I want all of the items to be displayed on one form.

I'm sorry if this was confusing, but if anyone could steer me in the right direction I would appreciate it very much.
Thanks.

 

[oharab]

Instead of using labels, cheat! Use text boxes with lookup formulae in and format them so they look like labels!


HTH


Ben ----------------------------------
Ben O'Hara
Home: bpo@RobotParade.co.uk
Work: bo104@westyorkshire.pnn.police.uk
Web:

http://www.RobotParade.co.uk

----------------------------------

 

[Guest_imported]

Is there a way that I can get the text boxes to save as the values that I change them to so that when I close and reopen the database, I won't have to type in each of the 40 items?

 

[Rolliee]

Sure, put them in a separate table and load from the table as needed.

rollie@bwsys.net