I was running the form. I just used notepad to see if the instance of HDPO was in there, and it was. Now I have to find it or start over. But that may work better.
I was running the form. I just used notepad to see if the instance of HDPO was in there, and it was. Now I have to find it or start over. But that may work better.
Does this shot give us a clue?
It's saying there was an issue using ODBC when using combo11 in form_PO_Receipt_label.
Perhaps there is a missing reference, or something is misspelled....???
PO_Receipt_Label is a label report, not Form.
Should this have said "90 MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure Combo11_AfterUpdate of VBA Document Form_PONUM"?
Access is just saying it's a document (form or report) but it is naming the item in question as form_PO_Receipt_label
Thank you again. I believe I have it working now. I will now move this to the production machine and see if I can get the report label to print out..... Keeping fingers crossed.
Hello. I need HHDESC to show along with HHPO. How can I do this? Thanks.
Private Sub Combo11_AfterUpdate()
Dim myFilter As String
10 On Error GoTo Combo11_AfterUpdate_Error
20 On Error GoTo Combo11_AfterUpdate_Error
30 Debug.Print "MyFilter is " & myFilter
'
' Line 20 tells Access to use the selection in Combo11
'to identify the single record of interest (to be printed)
'
'The debug.print lines are for debugging
40 myFilter = "HHPO =" & = "HHDESC =" & Me.Combo11 'which Purchase Order to show NOTE This is numeric so no quotes required
50 Debug.Print "MyFilter is " & myFilter
60 DoCmd.OpenReport "PO_Receipt_Label", acViewPreview, , myFilter
70 On Error GoTo 0
80 Exit Sub