Access sub form not loaded when using SQL tables

Question

I have a form in access with 5 nearly identical sub form . When I load the form it usually go fine. However, we recently changed from Access backend to SQL and since then , the form doesn't seem to load properly.

If I go to design mode and then to normal mode, everything loads fine. This, however, is not a viable option, the user can't do this.

Anyone had that problem or knows how to solve this ?

Edit Screenshot of the problem

1 : This is the first one , which worksl

2 : And this one does not.

3: Hoever, if I click on Design mode and then click on view mode againt, I see that it works, at least to some extant :

Thanks

Answer 1

I had this problem a long time ago with linked tables. Some kind of a connection problem. I think I fixed it by having my main Form open with its Subform pointing to a blank placeholder Form, and then via VBA (can't remember the Event) I replace the SubForm pointer with the name of the Form that was the real SubForm.