F
FBxiii
Hi.
I have got a form where the user can select various options for a report.
One option I want is for them to be able to select either All Customers or
just ones selected from a list box.
I have created some code to generate an In statement using the selected
customers. This works fine.
I am trying to apply the criteria of:
Field: Customer Criteria: [forms]![frmSAR_Statistics]![cmbCustomer] = "All
Customers" OR Get_Customer_List()
Get_Customer_List is the function I have created to return the list -
In("Customer1","Customer2")
If I run the query when All Customers is selected, it works fine.
When I select certain customers, the query comes back blank. I am
definitely selecting customers who appear on the All Customers report.
Can anyone help with this?
Cheers,
Steve.
I have got a form where the user can select various options for a report.
One option I want is for them to be able to select either All Customers or
just ones selected from a list box.
I have created some code to generate an In statement using the selected
customers. This works fine.
I am trying to apply the criteria of:
Field: Customer Criteria: [forms]![frmSAR_Statistics]![cmbCustomer] = "All
Customers" OR Get_Customer_List()
Get_Customer_List is the function I have created to return the list -
In("Customer1","Customer2")
If I run the query when All Customers is selected, it works fine.
When I select certain customers, the query comes back blank. I am
definitely selecting customers who appear on the All Customers report.
Can anyone help with this?
Cheers,
Steve.