Hello!
I have a lookup column in a db that looks up "Position" from a rank table, this then returns a value of the position (Rank) you choose.
I have made a search form using a query but when I search using a combo box that uses the rank table it returns a number....which is fine, but in the query it is returning any rank with that number.
Example I choose rank A from the combo box but it then returns A, BBA, CCA, AA, etc.
How can I make it return only the exact rank? Here is my expr from the query:
Expr3: [Position]=[Forms]![Main Form]![Combo51]
Any ideas most welcome :banghead:
I have a lookup column in a db that looks up "Position" from a rank table, this then returns a value of the position (Rank) you choose.
I have made a search form using a query but when I search using a combo box that uses the rank table it returns a number....which is fine, but in the query it is returning any rank with that number.
Example I choose rank A from the combo box but it then returns A, BBA, CCA, AA, etc.
How can I make it return only the exact rank? Here is my expr from the query:
Expr3: [Position]=[Forms]![Main Form]![Combo51]
Any ideas most welcome :banghead: