The saga continues....
I'm not sure exactly how this one will work, but I'm working on creating a search form that will automatically filter the results as a user types in information into unbound text boxes. To see more of a history about this check out this link: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24522261.html
I've followed the advice and changed the code to use the filter property and orderby property now rather than changing the recordsource everytime, but I am still having the same issue with updating the filter property, using the .text property is what I have to do but I can't get the problem with SetFocus to work since focus is required to use the .text property. Is this the only way to do this or is there another way? Or is there a better way to update the filter than the way I'm currently going about it. I'll put my code below. Any ideas?
Let me know if there are any more details that you need.
If .cname.Text <> "" Then
length = Len(.cname.Text)
criteria = "(((Left(CompanyName, " & length & ")) = [Forms]![Search]![cname])) "
condition = True