Search form with Continous form

anishkgt

Registered User.
Local time
Today, 16:35
Joined
Nov 4, 2013
Messages
384
hi,

am a new to programming so bare with me please. :) I've been trying to create a search form and i see that the continuous form with text fields is the best way to go by.

So in the After Update event i use the set filter for each text box
Code:
[CustomerName]=[Forms]![frmSsssearch]![txtCustomer]
With that the txt field value has to be exact how can i use like in the query criteria to show
Code:
Like "" & forms!frmSearch!txtCustomer & "*"
 

Users who are viewing this thread

Back
Top Bottom