coping data from one table to another

[biscuitboy]

Hiya

I have two tables in my database. One is called Data and one is called userdetails. These tables contain different information. What I would like to be able to do is when the user hits the button the information in the "Username" coloumn in the userdetails table to be copied and pasted into the "username" field in the data table.

I have tried running update queries but without success and so was wondering if anyone knew of a macro or vba code I could use.

Best Regards

 

[PHV]

You may consider the DLookUp function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244