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.

 

[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?