How to print the hidden form using the visible form only - MS Access 1 Table and 2 Forms

[usmanghani_2654]

Hello All,
I have a Lost/Found property database which we use to keep record of the lost/found property and it is working fine.
As per our organization's policy, we keep the item(s) for up to three months in which if it gets restored to the owner then fair enough otherwise after three months the item(s) can be claimed by the "Finder". But for this very purpose we issue the Finder with a "Claim Receipt" which he/she should bring in when claiming for the item(s) after three months period. Therefore, It's just the right time to upgrade the database to a more professional level.

Right.
The database has one table and two forms.
One form (LostFoundForm) is visible to the user in which they enter data, this form has two sections; Item(s) & Finder's details and the second section is about Restoring details.
However the second form (ClaimReceiptForm) is hidden to the users (for manual data entry) and has only one section which is exactly the same as the first form's first section, i.e., Item(s) & Finder's details. This second form takes the data automatically from the first form because the table behind them is same and fields are same (please see attachment). Up to here it's all working fine.

I would like to introduce a Checkbox or a CommandButton in the LostFoundForm which when we click should pull up a msgbox asking "Do you want to print the receipt for this item(s)?" with a Yes/No option. On clicking "No" it should, obviously, settle down but on clicking "Yes" it should print the "corresponding record" from the ClaimReceiptForm.

So here's the million dollar question, "How can I do this?"



Any relevant help would be much appreciated,

Regards.

Usman

[June7]

Build a report for printing receipt record.

Then code can be like:

DoCmd.RunCommand acCmdSaveRecord
If MsgBox("Do you want to print receipt for this item?", vbYesNo) = vbYes Then
DoCmd.OpenReport "Receipt", , , "ID=" & Me.ID
End If

This will generate a report for the current record of the form.

The default open for a report is direct to default printer.

[usmanghani_2654]

Thank you for your reply June7, but what's the "ID=" & Me.ID here?

[June7]

That is filter criteria example. ID would be unique record identifier (primary key) and Me.ID is reference to that field/control on the 'visible' form - use actual names from your db.

Reports are intended for printing and forms are intended for screen view. Each can be forced to do the other but not always with best results.