iworkonline
Registered User.
- Local time
- Yesterday, 22:32
- Joined
- May 25, 2010
- Messages
- 44
I am running the following search query on a table [Par_Client] containing 77195 records
The application is crashing when I run this.
My program is setup like so.
A form containg the text box and the command button.
Text box [txtName] contains the search string and the code behind command button is
the sql code is above for the qrySearchParent
I would appreicate any suggestions on improving my code.
Thanks
Code:
SELECT [Par-Client].Parent_Name, [Par-Client].CLast, [Par-Client].CFrst
FROM [Par-Client]
WHERE ((([Par-Client].Parent_Name) Like [Forms]![frmSearchParent]![txtName] & "*"));
The application is crashing when I run this.
My program is setup like so.
A form containg the text box and the command button.
Text box [txtName] contains the search string and the code behind command button is
Code:
DoCmd.OpenQuery ("qrySearchParent")
I would appreicate any suggestions on improving my code.
Thanks