navigate, find, and delete records.

[hjeff71]

I have a form (datasheet view), with Project Number and Child Number

Each project can have childs (ie: Project 1001 can have 1001-1, 1001-2, 1001-3 etc)

I’d like to learn how to navigate through the data of the table and have the option to delete the record if:

- The project # or the child is the last one in the series.

1001
1002
1003 – Can be deleted because it is the last one

OR

1001
1001-1
1001-2
1001-3 – Can be deleted because it is the last one
1002 – Can NOT be deleted because there is a 1003
1003 – Can be deleted

View attached test.mdb for example.

 

[Rokhi]

Use the form_current event and set the form's allowdeletions property depending on conditions in the current record.

e.g.

    Me.AllowDeletions = Mid(Nz(text1), 3, 1) = "d"