Creating a form 'template'

[nickadeemus2002]

Please help. I have a database that contains a form with two subtables. As you complete a record, the form naturally creates a new form record number afterwards. What I would like to do is to create a template out of a single form record. In other words, if you input information on the form and the record number at the bottom is record number 28, I would like to freeze that form to where some inputs are permanent (like customer information, sales rep name, workers involved with the project) and the only things that would change are the quantities involved with the job each time it comes up. Is this possible?

Thanks for your time

 

[dcx693]

Yes, it's possible, but you'll have to do some coding. There are various techniques for this, among the easiest being using the "Tag" property of the fields involved.

Somehow, you'll need to tell your form which fields you want to freeze and use in your "template". Then you'll need to store the values you want to freeze in the Tag property of those fields. Then when you go to a new record, you'll need to tell the form how to bring those values out from the Tag property to being the actual field values. If you're freezing the same fields each time, that makes it easier.

Let me know if you're interested and I can post more info.

 

[nickadeemus2002]

Thanks for the offer to help. I am an access novice. I have only created one database app for my job because my boss thinks I'm the only one who can figure this stuff out. I purchased a book on Access 2000 but it doesn't give any detailed information about 'TAGS'. Any info you can give me will really help and I'll try to make sense out of it.

Thanks for your help