468,133 Members | 1,215 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Clear contents of unbound field form

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
2 13574
MMcCarthy
14,534 Expert Mod 8TB
You can clear the selection of lists on a form by adding the line of code

Me.Refresh
Aug 9 '06 #2
tkhouk
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.

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 gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.