VBA code to delete records from subform and autopopulate fields in Main Form.

[chickenwings23]

Hello. This may be confusing to explain but I'll try my best. I have a Main Form and Sub form. Main Form is frmEstimateBr and subform is subfrmEstimateBr.

When information is deleted from the subform, certain text boxes must autopopulate into the main form.

I have a Saved Record button in the Main Form that when a user clicks save, it performs the action of saving, and it reqrys back to the selected BrNumber. When the deletion of a record from the subform occurs, a requery of the selected BrNumber does not occur. I attached a picture to make it easier to see and the vba code below for the actions to work. Hope it understandable... struggling on this. I wanted to include a video but unable to.

 

[June7]

Exactly how are you calculating the textboxes on main form?
If you want to provide db for analysis, follow instructions at bottom of my post.

 

[arnelgp]

...
...
LResponse = MsgBox("Are you sure to Delete the Record(s) selected?", vbYesNo, "Delete Business Record")


If LResponse = vbYes Then
With Me.[SubfrmEstimateBr].Form.RecordsetClone
If Not (.BOF And .EOF) Then
.MoveFirst
End If
Do Until .EOF
.Delete
.MoveNext
Loop
End With
.
..
...

 

[arnelgp]

there is some sort of corruption on your db.
i imported to new db.
it will now delete record from subform.

 

[Pat Hartman]

it performs the action of saving, and it reqrys back to the selected BrNumber.

Saving a record using a proper method does NOT move the form off the current record. You are misusing the .Requery method. You should probably read the help entry on requery. Saving the current record is a side effect of its real task which is to rerun the query that the form is bound to. The side effect of that is that you lose your current position.

Deleting a subform record by using a button on the main form is extremely dangerous. Delete buttons, if you use them, belong on the row being deleted. You are assuming the user understands which record will be deleted even when it might not be currently visible on the subform.

 

[arnelgp]

ok test it again.

 

[arnelgp]

both the Main form and the subform is using Same Table?
you should make the Mainform Unbound.

 

[June7]

Is this an effort to emulate a split form?