As per above thread, thanks to you guys the button did work and I have since added a button to delete unneeded records for a given ID but really want to assign times to models with no previous records.

Logic is like this:

Insert new record(s) in to FINLDATA MODELS for each model listed in T_MODEL_LIST without a record in FINLDATA MODELS for a specific FINLDATA_ID

' Insert new record with ID and model code
INSERT INTO [FINLDATA MODELS] (FINLDATA_ID, MODEL)
' Select all models in T_MODELS_LIST that don't appear in FINLDATA MODELS
SELECT * FROM T_MODELS_LIST.MODEL
WHERE NOT EXISTS (SELECT * FROM T_MODELS_LIST. WHERE [FINLDATA MODELS.MODEL = T_MODELS_LIST.MODEL)

The MODEL_ID is a unique value that counts up with each new record added, for example if I manually type a new record in to this table now it will be something like 570001, if I go to another ID and add another record immediately it will have an ID of 5700002. The ID is what populates the form and everything I edit.

I'm close but struggling with the logic, my fingers are cramping with the amount of copy pasting im doing...