Search results

Done as you suggested max and it works like a treat. Thanks for all the tips :)

Thanks for the tip on using just the one report, after a bit of reading up i found the option to use filters, hopefully this looks a bit better: Private Sub cmdPrintPreview_Click() If IsNull(cboGenres) Then DoCmd.OpenReport "rptWanted", acViewPreview End If If...

Would love to have only one report but haven't quite figured that bit out yet :confused:

Thanks guys, that runs nice and smooth. I got a bit carried away with the Else commands :eek: I'm just experimenting with Access to build a database for all my records, i'll try the Case statement. Are there any pro and cons for using a Case instead of If/Else? Thanks again

Having a problem with the following code: Private Sub cmdPrintPreview_Click() If Forms!frmWantedReports!cboGenres = "Chart" Then DoCmd.OpenReport "rptWantedChart", acPreview Else If Forms!frmWantedReports!cboGenres = "Dancehall/Reggae" Then DoCmd.OpenReport...