Printing only a selected drop-down in form mode

[jgable]

I have my form all set up, but when I select a choice from my drop-down menu (it then populates several other fields) and press print, it prints a form for all possible drop-down items. I would like to disable print in such a way that it only prints the form for the selected drop-down. I am aware of the "print selected" option in print mode, but many other people will be using this who will not know to do that and I don't want hundreds of pages going to waste everytime someone besides me prints.

[huongdl1987]

You can form a button click next to the drop-down combo box. Here is an example- of course, in this example, I just pick a word document, not a form. But you get the general idea

Public Function PrintItem(strDocPath As String)

'if no path is passed to function, exit

If IsNull(strDocPath) or strDocPath = "" Then
Exit Function
End If

Dim dbs As Database
Dim objWord As Object
Dim PrintResponse

Set dbs = CurrentDb

'create reference to Word Object

Set objWord = CreateObject("Word.Application")

PrintResponse = MsgBox("Print this document?", vbYesNo)
If PrintResponse = vbYes Then
objWord.ActiveDocument.PrintOut Background:=False
End If

'release all objects
Set objWord = Nothing
Set dbs = Nothing

End Function

Private Sub cmdPrint_Click()

If Not Len(combobox.Value) = 0 Then
PrintItem(combobox.Value)
Else
MsgBox "Select Form"
End If
End Sub