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
With that the txt field value has to be exact how can i use like in the query criteria to show
am a new to programming so bare with me please.
So in the After Update event i use the set filter for each text box
Code:
[CustomerName]=[Forms]![frmSsssearch]![txtCustomer]
Code:
Like "" & forms!frmSearch!txtCustomer & "*"