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.
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.