Good afternoon you amazing Access geniusis!
I've ran into a problem with trying to only add a record and not bring up the entire table with my Access Form using a recordset as the connection to the SQL Server. All i want to do is add records to the table. can anyone help me with this.
here is the code i used:
it brings all records up when i change out the ",dbAppendOnly" to ",dbSeeChanges" but i only want to append records to the table.
I've ran into a problem with trying to only add a record and not bring up the entire table with my Access Form using a recordset as the connection to the SQL Server. All i want to do is add records to the table. can anyone help me with this.
here is the code i used:
Code:
Dim sqlMain As String
Dim rsMain As DAO.Recordset
sqlMain = "SELECT * FROM tblPRF"
Set rsMain = sqlDB().OpenRecordset(sqlMain, dbOpenDynaset, dbAppendOnly)
Set Me.Recordset = rsMain
it brings all records up when i change out the ",dbAppendOnly" to ",dbSeeChanges" but i only want to append records to the table.