Code to copy data from one field to another?

[graffiti]

Hi.

I know this will be one of the most basic questions you ever get asked in this forum, and for that I apologise, but when I read books and google I get so much info that is not related. I'm now confused!



An example of my problem:

Table1 has a field called "name"
Table2 has a field called "Who"

Table 1 will hold details of the person currently logged in. When an event is called I want VBA code to copy "name" from Table1 and put in in a new record in Table2, (along with dates and times).

I assume I need to work with recordset?






Aside.
This was one of my google searches. "Access 2003 copy field to new record".

I can now:

• use buttons to copy from one place to another, create a new database in A2007,
• Assign some default values,
• get vauge instructions: "Then, in the OnCurrent event of the new
  Record, copy the content of the variables to the appropriate Controls on the new Record." HOW??
• And so on, but nothing useful so far!

Thanks for your help.

[hertfordkc]

you could create a query to get the current user info and integrate that into an 'update' query. I always work with the query design and build queries if I have to, rather than try to write in SQL.
Yes you can certainly do it with VBA if necessary. Did the example you mentioned show you how to create a recordset object?
http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx