how create msgbox in main form if subform datachange

  • Thread starter Thread starter Amin
  • Start date Start date
A

Amin

hi,

i have main form and in that sub form (which is based on query..) now i
want to create a msgbox ot pop up
if data into sub form is changed.. (update for edit done..
and exitiing subform )...

Thanks in advance

amin
 
hi,

i have main form and in that sub form (which is based on query..) now i
want to create a msgbox ot pop up
if data into sub form is changed.. (update for edit done..
and exitiing subform )...
Click to expand...

Use the Subform's AfterUpdate event. The msgbox isn't "in" the main
form or the subform either - it pops up above any forms that are open:

Private Sub Form_AfterUpdate()
MsgBox "Update for edit done", vbOKOnly
End Sub

I'm wondering WHY you would want to do this - I would presume the user
would know that they were editing data!
 
hi,
Thanks you very much.. for replying....

the reason for that is .. in main form there are few subform.. on those
data calculations are done .. and displayed on main form..
some data in one form if data changed all calc is is difrent than previous..
(some of the figusres not caluations .. stored in table.. )
so msgbox alert .. provide some alert..( its the Billing program..)

Thank you very much....appreciate
amin
 
Back
Top