Little_Anj
Registered User.
- Local time
- Today, 23:11
- Joined
- Dec 14, 2012
- Messages
- 25
I have a Main form with a sub form.
The main form is a customer record (form view), and the sub form is all other customers (same fields) datasheet view.
I have a navigation bar to filter (using different queries) the results in the sub form
same postcode
Same company (different location)
everyone except Main form customer
I cannot get a different filter (Query) to show only customers whose name begins with the same letter as the customer in the main form?
I have been trying Like but think I am referencing it wrong, as it prompts me to enter a value rather than using the value in the field in the main form.
This is what I have in the query (of the subform)
Customer ID: <>[Forms]![NewAllCustomerListF]![CustomerID]
Customer Name: Like "[Forms]![NewAllCustomerListF]![CustomerName]" & "*"
The main form is a customer record (form view), and the sub form is all other customers (same fields) datasheet view.
I have a navigation bar to filter (using different queries) the results in the sub form
same postcode
Same company (different location)
everyone except Main form customer
I cannot get a different filter (Query) to show only customers whose name begins with the same letter as the customer in the main form?
I have been trying Like but think I am referencing it wrong, as it prompts me to enter a value rather than using the value in the field in the main form.
This is what I have in the query (of the subform)
Customer ID: <>[Forms]![NewAllCustomerListF]![CustomerID]
Customer Name: Like "[Forms]![NewAllCustomerListF]![CustomerName]" & "*"