Hey!

I need help with a project I am working on. I need to lookup a record in a access database.

Basically, I have created a form with a textbox and a button. What I want to happen is you enter in your ID and it will look up a record in a table called Whoishere and move the record to a table called History.

Any help would be great!!

Richard