Help with a button in a form

[methodmza_uk]

Hi guys,

I am really struggling with this. I have 2 tables, 1 called Current and 1 called Previous.
Each table has all my users current and previous.
I want to add a button in a form that when you are viewing a certain record you can click the button and its moved from Current to Previous.

I have seen some posts about ammend queries and I am confused as to what they are and how to use them. I would prefer some code but which ever way is easiest.

I am a real novice with access and programming and woul appreciate some help from you lot

Thanks a lots in advance

ben

 

[CEH]

Why 2 tables? Current and previous would have many fields the same..... Why not one table... a look up field for User Status.

 

[methodmza_uk]

Eh if you dont know how to do it what you posting on here for?

Anyways, i have done it now. Thanks

 

[ghudson]

Please do not double post your questions in different sections of this forum. You are only wasting the time and resources of those involved.

http://www.access-programmers.co.uk/forums/showthread.php?t=97441

Searching the forum is a great way to discover and learch the answers to your Access programming questions.