Locking invoice form after printing

eyalco

Registered User.
Local time
Yesterday, 17:52
Joined
Jul 24, 2007
Messages
50
I'm creating an invoice software (access 2000).
Need to consult which is the best way to lock form and subform after saving and printing.
The code I think of using is :
select case me.status
case 1 :'open'
me.allow deletions =true
case 2: 'closed'
me allow deletions=false.
end select.
end sub

My questions:
1. What kind of operations more should I state in the code?
2. should I allow edits in the closed form?
3. I need to put a bypass button to the locking of the form. HOW?
Thanks for your help.
 
Fwiw

I would do it differently:
Use the tag property of the controls you want to lock. Fill them with LOCKME or something more descriptive. loop through the controls on your form, if the tag property matches LOCKME lock the control.
It is easy to unlock them.
 

Users who are viewing this thread

Back
Top Bottom