This is not the solution.
A delete button is already placed in the subform.
What is the VBA code for deleting a specific record when I know the ID of the record?
Instead of Me.Recordset.Delete?
Like this?
DoCmd.RunCommand acCmdDeleteRecord
or
Dim strSQL As String
strSQL = "DELETE FROM...
I have attached a screenshot of the form.
The delete button we programmed ourselves.
It should delete the current record. In this example the empty record.
However it deletes the first record.
Does anyone know a solution?
Hello,
We have an Access programming problem.
When we browse through records in a subform we store the records in the database.
When we want to delete a records for example the third record from the five records always the first records will be deleted. How can we delete the records where the...
Dear Access expert,
We get an access 3624 error for a long time now. (Cannot read the record. The record is currently used by another user an dis locked.).
We cannot solve it.
We solved it temporary by switching of the referential integrity relationsship.
But is this the right solution?
Can...