I have a table: "tCl" in MS Access 2003, In that table we have a string ("CL") that can contain data like:
ACU Blue 6PK
ACU Blue 12PK
ACU Blue Large 24PK
ACU Blue Large 6PK
For various reason the user might have a form with an entry (Me.ODBrand) of "ACU Blue" or ACU Blue Large"
Was wondering how I can retrieve the full one of these matches of "CL".
For example if the user enters ACU Blue to return either ACU Blue 6PK or ACU Blue 12PK (Preferable the larger PK but I would be happy with either) for latter data handling on the form.