Writing to a different table than the record souce

[virgilio]

I'm (still) working on a project to port our current setup in which we are using Excel as a front end via ADO to interface with Access. My project is to build an Access front end. Most of my forms are tied to single table, but there are few situations where I want to send some values to another table. These tables aren't linked in the relations page, but they could be because the FK's should match. I know that I can accomplish this with stringified SQL commands, but is there a built-in method that makes this easier?

Paul



I tried doing something like this:

Me.RecordSource = "table_2"
Me.private_NUM = privateNUM
Me.RecordSource = "table_1"

but it didn't recognize the field "me.private_NUM" from table_2. Am I stuck writing SQL?

[ranman256]

You don't need 'SQL'... Use a query.
The query can read the value in the form and add it to the 2nd table. (Append query)