Print a specific record

[NISMOJim]

I'm working on an inventory db, and am having several problems with coding, which I am pretty new at. I'll start with this problem, and continue my search for answers to the other problems while waiting for advice.

I'm currently working on a form for the user to see or enter part information. This form (InventoryDetailed) is tied to the Inventory table through the qryInventory query, and has Indx (Autonumber) as a primary key. At the bottom of the form are 2 command buttons, Print Label and Save Record.

The Save button works fine, as all it does is close the form, and the record is automatically saved. The problem I am having is how can I get the Print Label button to show a report of the record that the user just typed in, but is not yet saved to a table? If this button is clicked, the form should close, and the report should open.

Another potential problem, this form is also used to view detailed information on records that are already in the table. A new undamaged label may need to be printed for a part already in inventory.

Thanks again for all of your help, past, present and future.

[pbaldy]

You can use this to force the record to save before printing:

DoCmd.RunCommand acCmdSaveRecord

If you need a method to print only the displayed records, I use this a lot:

http://www.baldyweb.com/wherecondition.htm

[NISMOJim]

Thanks for the response. This is saving to the table now, and I did use the "Where" method to display the correct report, but now I get a run-time error '2497': The action or method requires a report name argument. Here's the code...

Private Sub CmdPrtLbl_Click()
Dim strFrm As String
Dim varID As Integer
strFrm = "frmInventoryDetail"
varID = Me!Indx

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport rptTireLabel, acViewPreview, , "[Indx] = " & varID

End Sub

I don't know enough about code to decipher the problem. Most of what I've learned about VB is from these posts, so maybe I'm using things out of context. Any more advise?

[pbaldy]

Like many, the report name is a string argument. You could use a variable like that, but the actual report name has to be in quotes:

DoCmd.OpenReport "rptTireLabel", acViewPreview, , "[Indx] = " & varID

[NISMOJim]

Works perfectly, thank you. Glad it was such an easy fix. I'll post my next question in a new thread.
Thanks again.

[pbaldy]

No problemo!