I have a sub form that is linked to the main form via a query using the REQUEST_ID. I want to capture the sub form controls data and input it into a table.
My VBA is not working as I am not able to reference the sub forms controls. I want to insert into BD_TRAN where the fields in the table are set equal to the values on the form.
Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset("BD_TRAN ")
'.Fields("Request_ID") = [Forms]![frmRetrieval]![REQUEST_ID].Value
'.Fields("Source") = [Forms]![frmRetrieval]![DESTINATION]!Value
'.Fields("RDBMS_SCHEMA") = [Forms]![frmRetrieval]![RDBMS_SCHEMA].Value