Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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
Join the community of 500,000 technology professionals and ask your questions.