freeze a object

is there a way to freeze an object for instance if you have a date you want to freeze (can't change or change when you go to another form) how would you do it
i thought (locked would work but it still changes) or (disabled)

lee123

re: freeze a object

Several questions:

Where is your date stored?
How is it called (i.e. do you have a label with source something like this =Now())?

If you want to display a static date associated with a certain record on a form, then you will need to put a date field in the table that stores the record. Simply add a locked/disabled text field (or label if you wish) to the form displaying the record, the date stored will be displayed and will not update until you physically update it in the underlying table.

If you are dynamically creating the date with a =Now() or =DatePart(), you will need to take a few more steps to get the date stored in a static place.

A more concise/clear explanation including answers to the above questions will help shed more light on your problem!

re: freeze a object

yes i have a date txt box its called (date) if you scroll down the list of questions(on the main form) there is a question called (control source) read that because this question is part of that form i just thought i would post a new question because that question is getting further down the list i think the question is # 60 now i think the text box is calles (text9)

lee123

re: freeze a object

If you post a reply to your original question, it will bring it back to the top of the forum listing.

Please do that, as Rabbit is working with you on this issue.

Regards,
Scott

re: freeze a object

ok thanks i'll do that

re: freeze a object

And if you’re actually saying that the text box name is date you need to change that to something else, such as txtDate! Date is a reserved word in Access and you're likely to get into all kinds of trouble using it as a control/field name! For a detailed explaination and a list of Reserved Words you should look here:

http://www.thescripts.com/forum/thread659167.html

Good Luck!

Linq ;0)>