Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Access sub form not loaded when using SQL tables

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

enter image description here

2 : And this one does not.

enter image description here

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 :

enter image description here

Thanks

like image 493
David Brunelle Avatar asked Feb 03 '16 21:02

David Brunelle


1 Answers

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.

like image 112
VolleyballAddictSandiego Avatar answered Oct 02 '22 23:10

VolleyballAddictSandiego