Open report based on Two combo Selections (Category & Report Name)

[mba_110]

Hi everyone,

I am doing a small exercise for opening report from my form based on report name as i have 100 reports so it need to be done very precisely however i have a table called tblRepots which has category, Reportname, and Reportlocation actually reportLocation is the real/saved name of report and Report name is the detailed name for users to open it from frmExtindividualRpts with btnPrintPreview.

Here is i have a code but unable to complete it, any help here will be much appreciated.

Private Sub BtnPrintPreview_Click()
On Error GoTo errhandlers:


'Check to see if data is entered into the Combo boxes or not.


If IsNull(Me.cboEmpId_RC) Or cboEmpId_RC = "" Then
    MsgBox "You must select Employee ID !", vbOKOnly, "Required Data"
If IsNull(Me.cboCatagory) Or cboCatagory = "" Then
    MsgBox "You must select Report Catagory !", vbOKOnly, "Required Data"
If IsNull(Me.cboReportName) Or cboReportName = "" Then
    MsgBox "You must select Report name !", vbOKOnly, "Required Data"
Else






exit_errhandlers:Exit Sub
errhandlers:
    MsgBox Err.Description, vbCritical
    Err.Clear
    End Sub

I need the else area code if all are correct then that specific report need to open, i dont know it can be done referencing the table field or any other method.

Thanks

 

[ranman256]

Private Sub btnPrintPreview_Click()
On Error GoTo errhandlers:

if not IsNull(cboEmpId_RC) then sWhere= "[field]='" & Me.cboEmpId_RC & "'"

docmd.OpenReport Me.cboReportName ,acViewPreview ,,sWhere

exit sub
errhandlers:
msgbox Err.description,,err
end sub

 

[mba_110]

Many Thks but the situation here is now i have to rename the reports to the combo box selection.

the field ReportLocation is stands for real report name which i cannot mention on combo box, otherwise users will get confused with short name of report.

that's why i have added the field in tblReports as [reportLocation] just not to confuse the users.

and also when cboEmpId_RC stay blank then it should ask to select it before proceeding the task.

"tblReports",[ReportLocation] is a real name saved in this field for reports.
cboReportName is a combo box with report Name for users who don't know the access coding.

I need to tell that cboReportName selection should open the report mentioned in tblreports,[ReportLocation] based on cboEmpId_RC which has actual name of report saved in DB, same should be applied for remaining reports command should follow the tblreports field reportlocation based on combo selection but open the only name saved in reportlocation field.


Sounds like complicated, sorry for bothering you again.