Hello, I have watched Access Developer 8 and the 1st lesson in Access Developer 9; so, I decided to build my own "Search as you Type" Form. Everything went great and as Richard taught in his class; however, I wanted to add a button to clear the Search Field as well. The button does clear the “Search Field”; however, it does not restore the names in the list. The list stays filtered. As usual any help is greatly appreciated. One more thing; please let me know the best or the proper command to use the clear the “Search Field”. These are the 2 that I tried.
Me.SearchBox = Clear Me.SearchBox = Null
Joe Holland
@Reply 5 months ago
Requery the recordset
Amir OuranusOP
@Reply 5 months ago
Awesome!!!
Thank you Joe!!!
Joe Holland
@Reply 5 months ago
My pleasure.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
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 9.