No changes after printing

[mwandira]

My database is a Reservations System. I want the following to happen:

1. Once a booking has been made it CAN be modified and cancelled.

2. Once the ticket has been issued (printed) it CANNOT be modified.

3. Once reprinted the words "DUPLICATE" should appear on the face of the reprinted ticket

4. Keep track of who made what changes.

 

[ScottGem]

Add a Yes/No or a date field to your table. If you use a Yes/No field default it to False and set it to True when a ticket is printed. If you use a Date field, store the date the ticket was printed.

In the On Current event of your form yuse code like:

IF IsNull(me.txtTicketPrinted) Then
MeAllowEdits = False
Else
Me.AllowEdits = True
End If

Use If Me.chkTicketsPrinted Then if you use a Yes/No field.

Similar code can be used when printing to create a watermark.

As for recording who made changes that depends on how you identify users.

 

[mwandira]

Thanks a million times.

It work with minor changes in the code though.

 

[ScottGem]

glad to assist. Most code snippets you will get here do need to be tweaked to work in your specific situation.