Delete record row from table (1 Viewer)

Jaydee-187 · May 11, 2017

From my form, I am able to enter information into four unbound boxes which saves the data to a table named tblFeedingActual. How can I delete the last record row entered (sorted by ID) from my form. I am using access 2010 and vb.
Thanks

plog · May 11, 2017

What have you tried? My solution would be in VBA and here's the broad strokes:

1. Use DMax (https://www.techonthenet.com/access/functions/domain/dmax.php) to get the highest ID value.

2. I would then compose a string to hold my DELETE query (https://www.w3schools.com/sql/sql_delete.asp).

3. I would then run DoCmd.RunSQL (https://msdn.microsoft.com/en-us/library/office/ff194626.aspx) to do the deletion.

Delete record row from table (1 Viewer)

Jaydee-187

Registered User.

plog

Banishment Pending

Similar threads

Users who are viewing this thread