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