Thanks, I can play around with it. As a test (and practice for myself), I removed the Data Source for the form, and then created the below VBA procedure which adds the necessary records into the table through SQL Insert.
This is all well and good, but now I can obviously no longer use the Record Selectors on the form to scroll through the existing records, and I don't really know how to restore that functionality without rebinding the table :-P (Other than adding a button which runs a basic 'Select' query to show the records in Datasheet mode)
So I'll re-bind it and see if I can make some updates to have it behave the way I want it to behave
Code:
Dim strDesc, strSubmitter As String
Dim strReqNum, strCat, strDB, strPri As Long
Dim strDate As String
Dim strSQL As String
'Populate with the current date
strDate = Format(Now(), "mm/dd/yyyy")
Me.cboCategory.SetFocus: strCat = Me.cboCategory.Value 'Category Dropdown List Selection
Me.cboDatabase.SetFocus: strDB = Me.cboDatabase.Value 'Database Dropdown List Selection
Me.cboPriority.SetFocus: strPri = Me.cboPriority.Value 'Priority Dropdown List Selection
Me.EDDP_Description.SetFocus: strDesc = Me.EDDP_Description.Value 'Description Text Box
Me.txtDateOpened.SetFocus: strDate = Me.txtDateOpened.Value 'Date Opened Text Box
Me.txtSubmittedBy.SetFocus: strSubmitter = Me.txtSubmittedBy.Value 'Submitted By Text Box
'Insert SQL - inserts records into tblEDG_Database_Development_Tracking
strSQL = "INSERT INTO tblEDG_Database_Development_Tracking (EDDT_Database_ID, EDDT_Category_ID, EDDT_Submitted_By, EDDT_Description, EDDT_Priority, EDDT_Date_Submitted)" & _
"VALUES ('" & strDB & "', '" & strCat & "', '" & strSubmitter & "', '" & strDesc & "', '" & strPri & "', '" & strDate & "')"
DoCmd.SetWarnings False