A
Arvi Laanemets
Hi
My project has an unbound main form with several tabs. On 3 of tabs are
embedded forms - a single one on every of them. On 4th tab (Registers) are
further tabs, which every one also contains an embedded form, like Units,
Accounts, etc. All forms on Registers tab are continous, and mostly have 1-2
editable fields only (ID fields are mostly autonumeric and not visible for
user).
Register tables, on which are based forms on Registers tab, serve as source
for various drop-down on other forms. When some entry in any register is
changed (edited/deleted/added), then according drop-down's need to be
refreshed. I'm trying to use form's AfterUpdate events for this. Like
Private Sub Form_AfterUpdate()
Me.Parent.Parent.FormName1.Form.ComboName1.Requery
Me.Parent..FormName.Form2.ComboName2.Requery
End Sub
My problem is, that when I change something in some register, the form's
AfterUpdate event sometimes is fired, and sometimes is not. P.e. I set the
breakpoint into event's code, activated the form, added an entry into
register, switched to another form - AfterUpdate event was not fired. I
switched back to register, and activated anothe record - the event was not
fired. I deleted the new entry - the event was not fired again! How to force
it be fired every time something was changed there?
Thanks in advance!
Arvi Laanemets
My project has an unbound main form with several tabs. On 3 of tabs are
embedded forms - a single one on every of them. On 4th tab (Registers) are
further tabs, which every one also contains an embedded form, like Units,
Accounts, etc. All forms on Registers tab are continous, and mostly have 1-2
editable fields only (ID fields are mostly autonumeric and not visible for
user).
Register tables, on which are based forms on Registers tab, serve as source
for various drop-down on other forms. When some entry in any register is
changed (edited/deleted/added), then according drop-down's need to be
refreshed. I'm trying to use form's AfterUpdate events for this. Like
Private Sub Form_AfterUpdate()
Me.Parent.Parent.FormName1.Form.ComboName1.Requery
Me.Parent..FormName.Form2.ComboName2.Requery
End Sub
My problem is, that when I change something in some register, the form's
AfterUpdate event sometimes is fired, and sometimes is not. P.e. I set the
breakpoint into event's code, activated the form, added an entry into
register, switched to another form - AfterUpdate event was not fired. I
switched back to register, and activated anothe record - the event was not
fired. I deleted the new entry - the event was not fired again! How to force
it be fired every time something was changed there?
Thanks in advance!
Arvi Laanemets