A text box entry on one form to populate two tables

Hello All,

I was intersted in a text box entry on one form populating two different tables. The one field in both tables are identified by the same name. Is this possible?

Thanks in advance.

Yes, it is possible.

Using SQL, I know of two ways to do this depending on your circumstances. If there is an existing record in the other table and you just want to update a field, you can use an UPDATE statement.


If creating a new record in the other table, an INSERT statment.


This is aircode and I put in the quotes to handle text fields. In the first example, I identified the record based on an ID field (primary key). The second does not need this since it is creating a record. Look up these types of statements for more examples in order to cater it to your needs.

Again, just one way of doing it using SQL. There are other options. This will also need to be in a VBA module on the form (a command button, event, etc.)

-dK