I have never tried this procedure before. I have a form that is bound to a query. I would like to add a new record in a different table with some of the information on the form. The table that I want to add the record is not bound to the form. I know this can be done, but don't have a clue how to do it.
The following code adds a record to a specific table.
Dim rsTable as RecordSet
Set rsTable = CurrentDb.OpenRecordset("SELECT * FROM TABLENAME;")
rsTable!FieldName = Value
rsTable!OtherFieldName = OtherValue
rsTable!AndSoOn = YetAnotherValue