A
Andy
I am having trouble setting a "Where" condition in an ApplyFilter Macro.
What I have is an Unbound Text Box called "NameSearch" in the header of a
form called "frmqryadtpatients" that contains a list 300,000 records from a
query, "qryadtpatients". The user can type a family name into this textbox
and hit enter to activate an AppyFilter macro. The apply filter macro has
the following as a "Where Condition" [last_name] Like
[Forms]![frmqryadtpatients]![NameSearch] where NameSearch is the Unbound Text
into which the user entered name to search for. This is working fine but I
have been trying to append a wildcard "*" to the end of the text string in
NameSearch and so it will return all the names that begin with what the user
typed in the NameSearch box (i.e. bru = bru, brule, brun, etc...). I have
failed so far using the help feature and I have tried numerous combinations
and permutations of &, +, ", '. In the Where Condition of an ApplyFilter
Macro I want to concatenate a "*" onto the end of the character string the
user entered into the NameSearch field.
Does someone know how to do this?
Thanks
Andy
What I have is an Unbound Text Box called "NameSearch" in the header of a
form called "frmqryadtpatients" that contains a list 300,000 records from a
query, "qryadtpatients". The user can type a family name into this textbox
and hit enter to activate an AppyFilter macro. The apply filter macro has
the following as a "Where Condition" [last_name] Like
[Forms]![frmqryadtpatients]![NameSearch] where NameSearch is the Unbound Text
into which the user entered name to search for. This is working fine but I
have been trying to append a wildcard "*" to the end of the text string in
NameSearch and so it will return all the names that begin with what the user
typed in the NameSearch box (i.e. bru = bru, brule, brun, etc...). I have
failed so far using the help feature and I have tried numerous combinations
and permutations of &, +, ", '. In the Where Condition of an ApplyFilter
Macro I want to concatenate a "*" onto the end of the character string the
user entered into the NameSearch field.
Does someone know how to do this?
Thanks
Andy