Add new record in primary and secordary table using VBA

[Moss100]

Hello I would like to add a new record in my main table PROPERTY and also in my secondary table OCCUPANTS using VBA, from an unbound form.


The database is call PERSONS
The PROPERTY table has autonumber field - ID
The OCCUPANTS table has a field PROPERTY_REF into which I need to insert the ID from the PROPERTY table to create the relationship.

Please could someone show me how to do this in VBA

Many thanks

Mark

 

[dhookom]

Isn't post this the same question as thread702-1710482

Duane
Hook'D on Access
MS Access MVP