Access to an additional form does not load when using SQL tables

Question

I have a form with access with 5 almost identical subforms. When I upload a form, it usually goes fine. However, we recently changed from Access backend to SQL, and since then the form does not seem to load properly.

If I go into design mode, and then into normal mode, everything loads fine. This, however, is not a viable option; the user cannot do this.

Has anyone had this problem or does she know how to solve it?

Edit Problem Screenshot

1: This is the first one that works

2: And this is not.

3: Hover, if I click on "Design Mode" and then find the view mode again, I see that it works, at least to some extent:

thanks

Answer 1

I had this problem a long time ago with related tables. Some kind of communication problem. I think I fixed this by opening my main form with its form pointing to the placeholder form, and then through VBA (I don't remember the event). I am replacing the SubForm pointer with the name of the form that was the real SubForm.

Answer 2

Indicate the recording source of your subform. AFAIK this behavior may be due to a synchronization problem. When you click Design Mode , and then return to View Mode , you have all the SQL sources (main and subform) that are already defined and initialized: time is no longer a problem.

In the Form_Current event of the main form, try to override the recording source of your subform , Requery it with Me.SubFormControl.Form.Requery .

Answer 3

There can be a lot of problems.

• Your subformation is already open.
• Your sub-form control is related to the fact that master-child ans has no records to display.
• Your subformation is connected as master-child and has a transit request as a data source.

I believe the culprit is the tabbed panel and duplicate subforms. Convert the tabbed panel to the navigation panel and reassign all subforms.

Remember that tabs will open all 5 subforms before loading the parent form, where repeating subforms will open only once (your problem)

On the other hand, the navigation bar will load each form on demand (when you go to the button). Try this and let us know.

Edit Also, I don’t quite understand why you will have 7 similar forms for every weekday! ideally, you will have one form, which day? but again this is a structural problem and has nothing to do with your question.