Storing selected fields to two tables

[laph]

I have two databases (DB 1 and DB 2) that linked together by a particular table. So database 1 could see a table in DB 2. Table1 belongs to DB1. Table2 belongs to DB2 but link to DB1.

- On this DB 1, we have a form that takes user input. The form ties to table1. Is there a procedure or method to automatically copies selected fields (not record) to the linked Table2? Ex: A form has 5 fields. I want to copy field 2 and 4 as soon as the information inserted into the table1. The fields are optional. So if no info entered, then null value is inserted to linked table2. I only want to copy the latest record that just entered. All information on that record will be entered into table1. To summarize what I want to do: selected fields on new record are stored into both tables at the same time. Table1 contains field1-5, table2 contains field2&4 after new record is entered.

I am wondering if this could be done with expression or VBA is needed. If so, is there an example that someone already put together.

Thanks,

LP

[DSnail]

LP, I don't know if this is appropriate on this site, but I would like some clarification:

1. By the nature of linked tables, are the necessary tables available in one database?

2. Is the form in question only for adding new records, or can it edit existing records?

Typically, I would use an update or append query to accomplish this...may not be the most efficient approach, but works well for me. If you could give me some insight, I would be happy to show you the code needed to accomplish your goal.

-=DS=-

[laph]

Hi DSnail,

1. Yes, the linked table shows up on DB1.
2. the form on DB1 can add new or edit current record.

As far as update or append, does it only append the lastest record with only selected fields that is being entered or just entered.

I am thinking about writing VBA code that runs after update. VBA will check to see if the is empty. If so then just ignore or add a null value. VBA will need to check current or latest record and copy the values to the link table. Do you have the code that does it? I am new to VBA.

Thanks,

LP

LP, I don't know if this is appropriate on this site, but I would like some clarification:

1. By the nature of linked tables, are the necessary tables available in one database?

2. Is the form in question only for adding new records, or can it edit existing records?

Typically, I would use an update or append query to accomplish this...may not be the most efficient approach, but works well for me. If you could give me some insight, I would be happy to show you the code needed to accomplish your goal.

-=DS=-