Prevent edit and delete after printing a form

[damie]

Hi everyone please i need an urgent help
I want my order details form, after printing to prevent deletion and edit.
I got this vba code to use, when i used it, it closed up all the forms including the ones i have not printed.
Normally i print immediately the order is made...
i dont know what to put ,"" <> ""

If Nz([OrderDate],"") <> "" Then 'there's a value there so the orders been printed
Me.AllowEdits = False


Me.AllowDeletions = False
Else
Me.AllowEdits = True
Me.AllowDeletions = True
End If

thanks so much for your help

[RuralGuy]

Try putting that in the Current Event of your form.

[damie]

Thanks for the reply
i tried putting it in the current event form but it is still locking up everything.
If Nz([OrderDate],"") <> "" ... am i suppose to put a date between the inverted commas, please how will i go about it
Thanks

[RuralGuy]

Any chance you can post your db, or at least a sample that demonstrates this issue?

[damie]

Thanks for your reply
I have added a sample of the database
what i want is after printing the form i want it to prevent deleting and editing of the record printed
but now everything is locked, even a new form
i don't want to use the complete order on the form
thanks

[RuralGuy]

Which form have you been working on?

[damie]

thanks for your reply
am working on the order details form
thanks

[RuralGuy]

If you completely comment out all of the code in the current event, does the form work as you want?

[damie]

Thank you for the reply
That is not what i want
I want it to be such that when i print the invoice of the form it prevents deleting and editing to that particular form.I don't want it to be that when they click on complete order that is when it would lock the form.
Thanks

[RuralGuy]

If you completely comment out all of the code in the current event, does the form work as you want?

I didn't say this correctly! I meant to say when you comment out the CurrentEvent code does the form at least go back to working? Mine does not.

[damie]

Thanks for your reply
I think some have the forms have been closed completely.
Please just try to open a new order as if you want to sell
Thanks

On the On current i just added set form state