D
DesB
I'm converting a legacy db (not my code!)
I have a form with a linked subform (master/child) with code in the subform load event
The subform code tests the value of a field in the subform and reacts accordingly
Sometimes the child subform has data, sometimes not, depending on the record in the main form
There seem to be two differences
(1) In Access 97 the load event seems to only fire if there is data to show in the subform - if no records, then no event
In Access 2003, it seems the event fires every time
(2) In Access 2003, in cases where there IS data for the subform, I get an error when the subform load-event code tests fieldname.value - "msg". In Access 97 this didn't happen - the value of the field was accessible (and the event didn't fire if no data - see (1) above) It seems event happens earlier in Access 2003
Has anyone seen a similar problem, or have any suggestions?
I have a form with a linked subform (master/child) with code in the subform load event
The subform code tests the value of a field in the subform and reacts accordingly
Sometimes the child subform has data, sometimes not, depending on the record in the main form
There seem to be two differences
(1) In Access 97 the load event seems to only fire if there is data to show in the subform - if no records, then no event
In Access 2003, it seems the event fires every time
(2) In Access 2003, in cases where there IS data for the subform, I get an error when the subform load-event code tests fieldname.value - "msg". In Access 97 this didn't happen - the value of the field was accessible (and the event didn't fire if no data - see (1) above) It seems event happens earlier in Access 2003
Has anyone seen a similar problem, or have any suggestions?