update table from query

http://www.techonthenet.com/access/queries/update2.php

see disable at end of article

http://office.microsoft.com/en-us/access-help/create-a-make-table-query-HA010108505.aspx#BM1

see disable at end of article

http://office.microsoft.com/en-us/access-help/create-a-make-table-query-HA010108505.aspx#BM1

compare value user and password

http://www.programmersheaven.com/mb/ASPNET/286028/286028/comparing-value-in-textbox-with-a-field-in-a-database/

password

http://stackoverflow.com/questions/5268235/access-2007-get-vb-user-login-and-record-for-last-modified-form

macro action reference

http://www.brainbell.com/tutorials/ms-office/Access_2003/Macro_Action_Reference.htm

Creating_And_Running_A_Macro.htm

http://www.brainbell.com/tutorials/ms-office/Access_2003/Creating_And_Running_A_Macro.htm