Placing Data in another Table

[alastair69]

Hello,

It has been some time since i have been on the forum.

My issue is this, i have a form called "JT History (New)" is need to copy some of the information into another table on close. I have tried to use the following:-

me.Clientlookup = [tables].[tbl Scheduler]![CompanyName]

This generates an error of "424, Object Required" can any body help me on this.

Kind Regards

Alastair Lane

 

[Kempes]

The way I would do this is to fire up an SQL statement on close.

eg

Docmd.runsql "SQL STATEMENT HERE"

If you aren't sure about SQL, create what you want in a query ensuring the criteria matches, change the query type to Append or Update query, then switch to SQL view to copy the statement.

Otherwise, save the query then just reference this query on close.

 

[alastair69]

Thanks Kempes,
I will give it ago.

Alastair