Please see the attachment.
Note that the sub-form on the right-hand side of the form that opens when you open the database has 4 line records. Obviously the sub-form is a continuous form. What I am having trouble with is this... If I delete the record that is red, (the top record), I get a message that says that someone else is using the database which is not true because I am the only one using it. Then I click [OK] on the message and the records display with #Deleted in all of the fields.
The delete method is doing exactly what it should be doing... delete all 4 records. But how do I get rid of the message that says another user is using the database, and, how do I make the #Deleted records go away? (A Refresh All does the trick but I don't want to have to click the Refresh All button.
Note, for developmental purposes should you decide to try to help me out... to get the 4 records back in the form just select "Equipment" from the Category drop-down and select "Some kind of line item" from the 2nd drop-down.
Any help would sure be appreciated.
--Steve
Note that the sub-form on the right-hand side of the form that opens when you open the database has 4 line records. Obviously the sub-form is a continuous form. What I am having trouble with is this... If I delete the record that is red, (the top record), I get a message that says that someone else is using the database which is not true because I am the only one using it. Then I click [OK] on the message and the records display with #Deleted in all of the fields.
The delete method is doing exactly what it should be doing... delete all 4 records. But how do I get rid of the message that says another user is using the database, and, how do I make the #Deleted records go away? (A Refresh All does the trick but I don't want to have to click the Refresh All button.
Note, for developmental purposes should you decide to try to help me out... to get the 4 records back in the form just select "Equipment" from the Category drop-down and select "Some kind of line item" from the 2nd drop-down.
Any help would sure be appreciated.
--Steve