Ahhhhh! Where did the subform go?

Question

I have a form called Group in my MS Access ADP. On it is a tab control, and in each of the tabs there is a subform. The first tab contains the subform Users, and it isn't showing up in form view. Subform Users shows up in design view.

Any clue as to why this might be happening?

Answer 1

Check that the subform control is in front of the tab control, not behind it.

Answer 2

As I understand you, you have a tab control with each tab having a subform. One of these subforms does not show up in Form View, but in Design view, correct?

Everything shows up in Design View, so it is normal that you see the subform there. It can have various reasons you are not seeing the subform in form view though:

• Please check if the subform control is on top (or on the tab control) of the tab control
• Make sure you set visible = true in the subform Users properties
• Make sure that DisplayWhen = "Always" or "Screen" and not "Print"

(Also take care that you set these properties for the subform in question and nothing else, it can sometimes be a hassle working with tab controls. You can check that you are working on the correct properties by looking on the selector drop down above the properties)

Answer 3

Apparently the problem is an incorrect SQL statement as a record-source for the form.