Appending Data to a Table

[Wicklund]

I am using the DLookup Function to pull data from a table (see below), and now I want to put that data into another table.

tempCompletionDt(z) = DLookup("[Mfg Completion Date]", "[Project Status - Tbl]", criteria(x))

I am able to do it using a Form as an interface, but I am sure that there is a better way.

Any Suggestions???

 

[chenn]

You could open a recordset and either update an existing record or add a new record. I beleive that would be the easiest.

set MyRecords = currentdb.openrecordset("MyTable", dbopendynaset)

With MyRecords
.addnew
!Field Name = Your dlookup function
.update
end with
MyRecords.close

 

[Wicklund]

Chenn - You are awsome! Thank you, it worked perfectly.

Pat - Thank you for your earlier help too....