Form showing blank in Formview

[Megacitizen]

I have a form which I intend to input data from a total of 6 tables (School_Ministry, Bases, Nations, TeamMembers, Focus City & Regions), numerous fields from the School_Ministry table and 1 field from each of the remaining ones. I am slowly building the form to add in the main fields from the first three tables listed ie "School or Ministry Name" "Base Name" and "Base Location", then getting the correct codes for the end user to be able to key in the info in the relevant fields.

However, once I start adding more fields from these and other tables in Design View, a quick check on FormView shows the form as completely blank. Deleting added fields in Design View does not, however, restore a view of the remaining fields in Form View. I have touched on this before and been informed that it's possibly corrupt tables or a corrupt form (unable to accept too much info).

Is there any way to get this issue solved. We have numerous DBs on our system which have forms displaying many fields. I can't see why the latest one shouldn't.

 

[Megacitizen]

Have found some possible theories to the above, on gooooogle, and am investigating each one . I'll be back to stretch your grey cells should I have no luck.

 

[Megacitizen]

Thanks Pat.

On closer inspection, one of my tables [Bases] is related, in a one-to-many relationship, with 2 others [School_Ministry] and [TeamMember]. I got rid of the latter relationship as I can link through the [School_Ministry] table instead. However, no luck yet.

I'm wanting TeamMember info to be on a subform anyway, so it can be hidden behind a Command button. At a guess, my Focus City field can be on a Subform as that rarely changes. If I can just get the Main Form to show the School/Ministry Name, Base Name, Nation & Region (of focus city), then that would be a start. It's building on from there where I hit the wall.

 

[Megacitizen]

Correct me if I'm wrong (probably am) but from the example above, I'm deducing that my MainForm should only be showing data from as few relationships as possible, preferably as little as 2 tables with one relationship, and all extra data required should be in the form of Subforms displayed on the Mainform.

I need to be able to demonstrate the relationships between 3 tables, ONE Nation MANY Bases and ONE Base MANY Teams. I think the problem occurs when I start adding in fields for WHERE the teams are going to. The School_Ministry table is the one on which we will be basing just about all our queries on this particular DB, main query being "where they're from and where they're going" as well as "what they did there", which is the main purpose for the DB.

 

[Megacitizen]

This is a hierarchy. You need nested forms. The main form will show Nations, the subform on the main form will show Bases, and the subform on the subform will show Teams.

OR

If Nations is mearly for reference (a lookup), the main form would show bases and the subform would be teams.

In this hierachal set up, can the Teams (schools) be set up as the Main form with Bases as subform and Nations subform on subform? - a reversal of your first scenario. I ask this because the teams are the central object of this particular DB, their tasks the subject.

 

[Megacitizen]

Trying to design subforms as suggested. However, my subforms only have one field each (the only fields we intend displaying) which displays no control label but has a MASSIVE form label, which I can't reduce in size to zero. I basically want to display labels only for the fields shown rather than each individual subform. Is this possible?