I HAve the following code which should in turn open up a report depending on the selection made in three combo boxes but for some reason it won't work
stDocName = DLookup("[Report_Name]", "Report_Config", "[Report_Group_No] = " & Forms!Report_Criteria_Selection!Group_Selection & "'" And "[Report_Type_No] = '" & Forms!Report_Criteria_Selection!Type_Selection & "'" And "[Lookup_ID]= '" & Forms!Report_Criteria_Selection!Criteria_Selection & "'")
Report_Group_No = Numeric
Report_Type_No = Numeric
Lookup_ID = Text
Any help much appreciated
Thanks
Geoff
stDocName = DLookup("[Report_Name]", "Report_Config", "[Report_Group_No] = " & Forms!Report_Criteria_Selection!Group_Selection & "'" And "[Report_Type_No] = '" & Forms!Report_Criteria_Selection!Type_Selection & "'" And "[Lookup_ID]= '" & Forms!Report_Criteria_Selection!Criteria_Selection & "'")
Report_Group_No = Numeric
Report_Type_No = Numeric
Lookup_ID = Text
Any help much appreciated
Thanks
Geoff