How to use combination of parameters in Access

[Guest]

Hi,
I have a combo box that lists two market channels A and B. There is the
third option in the combo box that is the value of C that is the consolidated
field. Now C should include all the values of A and of B in a table setting.


I am writing the above scenario for the parameter reference as follows:

If (Forms!frmReportsMenu!cboBusinessUnit = C) Then
Forms!frmReportsMenu!cboBusinessUnit = A Or B
Else
Forms!frmReportsMenu!cboBusinessUnit =
Forms!frmReportsMenu!cboBusinessUnit )
End If
This is not working as the parameter expression is evaluating into "C". Any
help is appreciated. Thanks in advance

 

[Marshall Barton]

I have a combo box that lists two market channels A and B. There is the
third option in the combo box that is the value of C that is the consolidated
field. Now C should include all the values of A and of B in a table setting.


I am writing the above scenario for the parameter reference as follows:

If (Forms!frmReportsMenu!cboBusinessUnit = C) Then
Forms!frmReportsMenu!cboBusinessUnit = A Or B
Else
Forms!frmReportsMenu!cboBusinessUnit =
Forms!frmReportsMenu!cboBusinessUnit )
End If
This is not working as the parameter expression is evaluating into "C". Any
help is appreciated. Thanks in advance

Parameter for what? If it's for a query's criteria, then
dump the code and change the criteria to something more
like:

=Forms!frmReportsMenu!cboBusinessUnit OR
(Forms!frmReportsMenu!cboBusinessUnit = "C")