Clear contents of unbound field form

tkhouk

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

MMcCarthy

You can clear the selection of lists on a form by adding the line of code

Me.Refresh

Aug 9 '06 #2

tkhouk

Thanks! This worked.

- Kevin

Aug 10 '06 #3