VB Script Checkbox to add new records

[iuianj07]

Hello guys,

I am creating a database that has 2 forms, Form1 which is bound to Table1 and Form2 which is bound to table2.

On Form1, there is a FacilityNumber(data field-primary key)textbox and an ASR Requested checkbox.
On Form2, there is a FacilityNumber(foreign key to Form1)


What I need to do though, is whenever the ASR Requested checkbox is checked, a new record will be created in Form2, with the corresponding FacilityNumber...

I think a VBA is needed for this one.

Any help is greatly appreciated.

Thank you

 

[jges]

If this is an MS Access database, you will get more help in forum705.

If it is a more generic VBA question, try forum707.