Hello Richard, I have this working I believe with a macro to open the selected customer as well, however I'm unable to add spaces into the text field. I may be missing the obvious but how can I add spaces so I can do like Fort Myers, Fort Lauderdale etc without just searching the last word?
Yeah, that's a tricky one. I'll have to think about it. The way I have the code written (if memory serves, it has been 2 years since I recorded that) every time you press a key the string gets "trimmed" so the trailing space would be removed. All I can think of is you'd need to keep a second hidden text box or memory variable with the actual value you type in that doesn't get trimmed.
Todd Auer
@Reply 6 years ago
I was able to accomplish the spaces by: 1.Make list box. Go to properties, select row source "...", Expr:1 [field 1] & [field 2] 2.Make a SearchBox. Go to properties and set the On Change with Code builder type DoCmd.Requery "List Box" 3.Like "*"& [Forms]![Form Name]![SearchBox].[Text] &"*" The .Text will select the text inside of the searchbox
I am also wondering how to make this happen with VBA, can't wait for the update. Thanks!
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 8.
