Subform's Form_Current is Triggered When Value in Parent Form is Changed

  • Thread starter Thread starter Robert Robichaud
  • Start date Start date
R

Robert Robichaud

I have a main form with 2 subforms.

Each subform is linked to the parent via LinkChildFields and
LinkMasterFields. Each time I set a value in the Parent form, the first
subform's Form_Current is triggered followed by the second's subform's
Form_Current. This only started to happen after I migrated from .mdb to
..adp.

Any suggestions?
 
When you move to a new record in the main form, Access has to locate the
right records to match in the subform (based on the
LinkMasterFields/LinkChildFields), and load them. Since this means loading
records into the subform, why would it Current event *not* fire?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:%[email protected]...
 
That's what I would expect and it does that.

My problem is that I'm only changing the value of some of the fields in the
main form and the Form_Current event is trigger in each subform. I am not
moving to another record.

Any ideas on what's going on?
 
Okay. What is in the LinkMasterFields: the name of a field in the main
form's RecordSource? The name of a *calculated* control?

Does this happen only when the main form record is saved?

Is there anything else that could trigger a recalculation (such as
conditional formatting)?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
 
The LinkMasterFields name is OrderID (Key Indexed field in the table Orders)
and is not a calculated field.

It happens when I change the value of a field on the main form that is tied
to the currently displayed record.

No. When stepping through in debug mode, after a field is assigned a valude
(e.g. Me!ShipDate = Now() ), the first subform's Form_Current is triggered.
As soon as the 1st Form_Current method is finished (via Exit Sub statement),
the 2nd subform's Form_Current is triggered. When the 2nd subform
Form_Current method is finished, it returns back to the next statement in
the main form.
 
Robert, I cannot reproduce that here in Access 2003.

I have a fairly simple main form (invoice), with a subform (invoice
details), and in the subform's Current event:
Debug.Print Me.Module.Name & ".Current fired at " & Now()

That fires (twice actually), when:
- the main form loads,
- the main form *saves*,
- the main form undoes,
- the main form moves record.

It does not fire when I type a value into a control in the main form, nor
when I programmatically assign a value to a control in the main form:
Forms(0).InvoiceDate = Date()
--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
 
Allen,

I should have mentioned in my first posting that I'm running Access 2000.
It should not make a difference but I'm still having this problem.

Any suggestions would be welcomed on what I should check for, reference
pages on the web or how to debug it?

Thanks.
 
Have just set up the same scenario in A2000. Same result. The subform's
Current event does not fire when the field is entered manually or
programmatically - not until the record is saved or undone.

Not sure what else to suggest.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
 
Allen,

Thank you anyways for trying to help. I've copied the source over to a new
..adp file and still receive the same results: both subform's Form_Current
are triggered when a field in the record is changed on the main form.

Been "googling" all over to try to find something on this but no luck. I'll
keep trying.

Regards,

Robert
 
To add to this, I'm running Access 2000 .adp.

If it helps, the Reference library is as follows:

Visual Basic For Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object library
Microsoft ActiveX data Objects 2.7 Library
Microsoft ActiveX Data Objects Recordset 2.8 Library

Suggestions?
 
Back
Top