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
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With