Updating Forms

[Guest]

Hello,
Thank you in advance for any suggestions!!

I have a form which takes its values from several tables
and queries. the data in the tables are prices that are
changed very frequently.
But, the users of the forms, do not need to have such a
frequent change. Often, it happens that the end users of
the form want to loom up for old values which they cannot.

If there is a way to 'freeze' the updating of the value in
the form and control its updating using a 'command button'
it would be helpful.
Any ideas or suggestions in this direction are most
welcome!.
Thank you.

PS: I have posted this message again, because my earlier
email did not describe my problem.

WIth Regards,
Swaminathan

 

[Guest]

Hello,

I am not exactly sure what u want, but you can LOCK a control for editing by
changing that property. So you can have a Button & in the OnClick Event of
that Button changing the controls that u want to Locked & then have another
button to Unlock for Editing again.

Example:

Private Sub cmdLock_Click()
txtName.Locked=True
End Sub


Private Sub cmdUnLock_Click()
txtName.Locked=False
End Sub


I hope this helps,
Jeff