New form opens with no fields

  • Thread starter Thread starter upsman via AccessMonster.com
  • Start date Start date
U

upsman via AccessMonster.com

I am creating a new form. The record source of the new form consists of 3
joined tables. The tables are:
Students
StudentID (PK)
LastName
FirstName
bunch of other fields

OldClasses
OldID (PK)
OldStudentID
OldClassID
OldGrade

NewClasses
NewID (PK)
NewStudentID
NewClassID
NewGrade

The tables are joined (one-to-many) Students --> OldClasses and also Students-
->NewClasses. Students is joined to both of the other tables by the
StudentID field. On the form, in Design View, I have StudenID, LastName,
FirstName, OldClassID, OldGrade, NewClassID, and NewGrade. But when I open
it in Form View, the screen is blank; none of my fields are there. I've
never had this happen before. If I remove one of the Class tables so that
Students is only joined to one other table, the fields show up on the screen.
They will not show up if I have Students joined to both Class tables. What
am I doing wrong or what Access rule am I violating? I can't have one table
joined to two others?
 
I can't have one table
joined to two others?
Click to expand...

Sure... but the resulting query will not be updateable, and as a
result will look blank on the screen. There will be no existing
records (because in your data no students are present in both tables),
and since the recordset is not updateable, you won't see the new
record either.

Consider an alternate approach: base a Form on the Students table,
with two Subforms, one on each related table. You'll find that this
works much better.

John W. Vinson[MVP]
 
That's an idea. Thank you.

John said:
Sure... but the resulting query will not be updateable, and as a
result will look blank on the screen. There will be no existing
records (because in your data no students are present in both tables),
and since the recordset is not updateable, you won't see the new
record either.

Consider an alternate approach: base a Form on the Students table,
with two Subforms, one on each related table. You'll find that this
works much better.

John W. Vinson[MVP]
Click to expand...
 
Back
Top