Changing a records in a table

[partizan82]

I want to find a record in first column <Employee ID> of a table <Employees> and then change the corresponding record in a second column <Password>, is there a function similar to DLookup but the one that changes values? Please help... thanks

[This message has been edited by partizan82 (edited 05-27-2002).]

 

[Rich]

Look up update queries

 

[partizan82]

i want to do it in vb... it should be pretty simple... basicly open the table -> find the right user -> change the password for it... but i don't know the code.....