By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,214 Members | 2,072 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,214 IT Pros & Developers. It's quick & easy.

Clear contents of unbound field form

P: 4
I have a small form with two unbound look-up fields (one for an ID and one for last name). Each unbound field has a command button that actually goes to my table and brings in the records.

How can I clear the contents of the form immediately once either one of the command buttons are pressed. I either want to do this **or** clear the contents of the look-up field whenever it is clicked or tabbed into.

I have a fairly limited knowledge of Access, so don't feel an answer is too simple to share :o

Thank you.

Kevin
Aug 8 '06 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
You can clear the selection of lists on a form by adding the line of code

Me.Refresh
Aug 9 '06 #2

P: 4
Thanks! This worked.

- Kevin
Aug 10 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.