Delete record row from table

[Jaydee-187]

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]

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.