How to use combination of parameters in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Jack said:
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
Click to expand...


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")
 
Back
Top