var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I am trying to set up a search that will behave like a wildcard (*'*) by default. In other words I would like to have the applyfilter command filter records and "match any part of the field." I am using the following code:
If Frame231 = 3 Then
rs = "CUST_NAME = '" & Me!Combo227 & "'"
This works fine as long as the entire (in this case) CUST_NAME is entered. I have tried many variations of "like", "*rs*" etc. These variations usually return a Syntax Error
rs = "CUST_NAME Like '*" & Me!Combo227 & "*'"
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors