Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
How would I define the conditions as the variable? Exactly where would I do that in the VBA code?
Private Sub cmd_Run_Report_Click() On Error GoTo cmd_Run_Report_Click_Err If (Eval("[Forms]![frm_TrainingByEe]![cbo_Shift] Is Null And [Forms]![frm_TrainingByEe]![cbo_Bank] Is Null And [Forms]![frm_TrainingByEe]![cbo_Flow_ID] Is Null And [Forms]![frm_TrainingByEe]![cbo_Queue_ID] Is Not Null")) Then DoCmd.OpenReport "rpt_Training_Employees", acViewReport, "", "[Queue_fk]=[Forms]![frm_TrainingByEe]![cbo_Queue_ID]", acNormal End If cmd_Run_Report_Click_Exit: Exit Sub cmd_Run_Report_Click_Err: MsgBox Error$ Resume cmd_Run_Report_Click_Exit
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|MIgrating Access 2003 to Access 2013, What changes are required?||7||40|
|Trying to export a table to another Access database file||2||19|
|Import multiple Excel files to different Access tables (same database) adding an extra column with the Excel`s filename||37||30|
|POPUP CHART TO DISPLAY FOR 5 SECONDS WHEN WORKBOOK OPENS||8||24|