Re: [MSAccessProfessionals] Main form with 2 subforms dissapear when in Form View #name

Hi Frank, 

When a form "vanishes" (controls are hidden) it is usually the result of a read-only form that doesn't display existing records. It might also have scrolled off the top of your screen. Do you have vertical scrollbars? Do you have any records in any table? Are the record sources just the tables or are they multiple tables? What are you Link Master/Child properties of your subform controls?

BTW: your Test table structure is sorely lacking regarding normalization. Typically, each test result would create its own record in a table rather than repeating columns.

Regards,

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Frank C. D'Amato - KB2MXV <kb2mxv@gmail.com>
Sent: Thursday, November 4, 2021 3:28 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Main form with 2 subforms dissapear when in Form View #name

 

I have new database with 3 tables and forms. I have attached some screenshots of my problem.

My main form (Customers) disappears when I try to view it in Form View.

When I look at my Instruments Form and its Subform Tests they show properly.

When I try to add the form Instruments as a subform to Customers, that's where my Customers form vanishes.

I did import all my databse items to a new database with no change.


--


Thanks
Frank D'Amato