alter_ego1981
Thread Starter
- Joined
- Jun 26, 2008
- Messages
- 49
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
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
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