Printing Particular Record from the form

[fabian24]

I am new to access. I was just making a small program where by I can print my permit to work.
I have made the front end , where the user can key in data and save the record.
How can I print the particular record from the form itself ?

I am attaching the access form.

You help will be very much appreciated.

Thanks

 

[ansentry]

Here is your database back and the printing is working.

Have a look at the code behind the "Print" button and you will see who it works.

 

[fabian24]

Thank you very much...

I have one more task...
Could we after issuing the print order lock the particular record from any further editing ??

 

[HiTechCoach]

See the attached for a way to lock the record after printing.

The basics of what I did are:
1) added a Date printed field to the table
2) the print button updates this field and lock the record (set the Allow Edits/Allow Deletions properties to false).
3) Use the On current event to check to see if there is a data printed, of there is, then lock the record (set the Allow Edits/Allow Deletions properties to false).


FYI: If this is your actual table, then you have some data normalization issues. You have lots of repeating fields that probably should be in a child/sub table. You probably should also have a site table, an people table,etc.