DoCmd.OpenForm Statement

[Nothing]

I have a form that the user types in a last name to search for then
clicks a search button.

Based on the information I want to open the form using the SQL Where
statement that will pattern match on the user input.

For example if the user enters char I want to the form to open with all
records based on char in the corrent field.

I can get the form to open fine if I type in a whole last name, it will
retreive the records but I can not get the LIKE statement in the SQL
Where part of the open form statement. Does that make sense?

Anyone have any ideas?

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Allen Browne]

DoCmd.OpenForm "Form1", WhereCondition:= "[corrent] Like """ & [Text1] &
"*"""

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Nothing" <[e-mail]> wrote in message
news:41**********************@news.newsgroups.ws.. .

I have a form that the user types in a last name to search for then
clicks a search button.

Based on the information I want to open the form using the SQL Where
statement that will pattern match on the user input.

For example if the user enters char I want to the form to open with all
records based on char in the corrent field.

I can get the form to open fine if I type in a whole last name, it will
retreive the records but I can not get the LIKE statement in the SQL
Where part of the open form statement. Does that make sense?

Anyone have any ideas?

Michael Charney