Child form loads before parent?

[DaveMere]

Hi,

I've got a parent/sub-form set up, both of which derive their data from linked tables connecting to a central database. As a result I've had to add coding to the NewRecord events to fetch the next primary keys from the database.

Unfortunately I'm finding that one loading the new record, the child form seems to be loading before the parent, ie the child form_Current event occurs before the parent form_Current event. Is this how it should be? It seems intuitive that the parent should load first.

I'm sure I can develop some cunning logic to get around this problem but I'm sure there must be a better way. Has anyone any experience of this parent/child set-up with linked, central database tables?

thanks!

Dave

 

[MartijnR]

hi Dave,

I have ran into a similar problem using parent/child forms and the on_current action, so this is a subscribtion to the thread as well.

Is there indeed a priority in the handling of actions?

 

[Oldsoftboss]

In all the testing I have done, the subform loads first. I'm not sure I understand the logic of this but I'm sure there is some.

Logic - Microsoft.... naaa

 

[MartijnR]

I am under the impression that on closing access, a subform remains longer than a parent form...