470,634 Members | 2,138 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,634 developers. It's quick & easy.

Clear contents of unbound field form

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.

Aug 8 '06 #1
2 13752
14,534 Expert Mod 8TB
You can clear the selection of lists on a form by adding the line of code

Aug 9 '06 #2
Thanks! This worked.

- Kevin
Aug 10 '06 #3

Post your reply

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

Similar topics

1 post views Thread by Stephan | last post: by
3 posts views Thread by Dos Lil | last post: by
2 posts views Thread by Dave Griffiths | last post: by
10 posts views Thread by Matthew Wells | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.