Solved: Access 2003, Multi If statements

[alter_ego1981]

Hi All,

I have been working on some multi if but i just need some help getting over the finishing line.

Background

2 x Yes/No Boxes

E_Single_Supplier
E_Multisite

So here goes

Private Sub E_Notice_Letter_Click()
If Me.E_Single_Supplier = -1 Then
If Me.E_MultiSite = -1 Then

DoCmd.OpenReport "Electricity_MultiSite_Report_1", acViewPreview
DoCmd.OpenReport "Electricity_MultiSite_Report_1a", acViewPreview
Else
DoCmd.OpenReport "Electricity_MultiSite_Report_2", acViewPreview
DoCmd.OpenReport "Electricity_MultiSite_Report_2a", acViewPreview
End If
End If

This works fine, however

I now need to build in

Same Supplier Yes
Multi Site No

Hope you can help, i feel like my head is going to explode

 

[OBP]

Where does "Same Supplier Yes" come from?

 

[alter_ego1981]

Same Supplier is a yes/no box which comes from tblUtilities, same location as E_Multisite.

Thanks

 

[OBP]

What Report are you going to run if the new requirements are met?
You can probably improve your code a bit with

Private Sub E_Notice_Letter_Click()
If Me.E_Single_Supplier = -1 and Me.E_MultiSite = -1 Then

DoCmd.OpenReport "Electricity_MultiSite_Report_1", acViewPreview
DoCmd.OpenReport "Electricity_MultiSite_Report_1a", acViewPreview
Else
DoCmd.OpenReport "Electricity_MultiSite_Report_2", acViewPreview
DoCmd.OpenReport "Electricity_MultiSite_Report_2a", acViewPreview

End If

 

[alter_ego1981]

Tony,

I have send you an email with more details.

Thanks

Euan