I have a form [frmSupervisors]. On it, I have a list box, [lstUnapprovedRpts]. Here's the SQL to it: SELECT [ReportID], [ReportTypeID], [ReportType], [OccDate], [BldgName], [FullName] FROM qryRPTUnapproved ORDER BY [OccDate], [FullName];
I'm trying to double click the list box and have it open them in a particular form. If [ReportTypeID]=2, I need it to open it up in [frmRptOR], If [ReportTypeID]=3, I need it to open it up in [frmRptSecurity]. If [ReportTypeID]=4, I need it to open it up in [frmRptAlarm]. All them need to go to the record, [ReportID].
I figure that I need an if statement. I just can't figure it out.