jleval
Registered User.
- Local time
- Yesterday, 23:34
- Joined
- May 16, 2012
- Messages
- 53
I have a dialog box that pops up to select a certain part number to print. In this dialog box is a combobox that has a list of my partnumbers. When I select a part number and hit the okay button I get this error:
Syntax error (missing operator) in query expression
Here is my code when I click the command button after selecting an item from the list
Dim strWhere As String
strWhere = Me.LookUpPartNumber 'name of combobox
DoCmd.OpenReport "Batch2", acViewPreview, , strWhere
DoCmd.Close acForm, "Batch", acSavePrompt
DoCmd.Close , "frmPrintDateRange"
What am I doing wrong?
Syntax error (missing operator) in query expression
Here is my code when I click the command button after selecting an item from the list
Dim strWhere As String
strWhere = Me.LookUpPartNumber 'name of combobox
DoCmd.OpenReport "Batch2", acViewPreview, , strWhere
DoCmd.Close acForm, "Batch", acSavePrompt
DoCmd.Close , "frmPrintDateRange"
What am I doing wrong?