Data in Subform Not Appearing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I found one post on this issue, but the "poster" did not follow through. I
have a main form and two subforms. In each instance, there is a one-to-many
relationship from main to sub. The Main's primary key is the foreign key in
each of the tables underlying each subform. I have the Master/Child links set
up for the primary/foreign key [TicketNum] and one other field, [State].

When I enter data in the subform it both is visible and is written correctly
to the underlying table, including foreign key and State field values.
However, when I switch off the main record to another one on the main form,
and then return to the one in which I had entered (sub) data, the record(s)
in the subform neither appear -- nor does the record count indicate that
there are subrecords associated with the record.

I have a relationship established between TicketNum in all three tables. I
have also written a Requery event procedure for both subs on the Activate
event of the main form. No change.

Can anyone give me information on how to solve this problem?
 
Susan L said:
I found one post on this issue, but the "poster" did not follow through. I
have a main form and two subforms. In each instance, there is a one-to-many
relationship from main to sub. The Main's primary key is the foreign key in
each of the tables underlying each subform. I have the Master/Child links set
up for the primary/foreign key [TicketNum] and one other field, [State].

When I enter data in the subform it both is visible and is written correctly
to the underlying table, including foreign key and State field values.
However, when I switch off the main record to another one on the main form,
and then return to the one in which I had entered (sub) data, the record(s)
in the subform neither appear -- nor does the record count indicate that
there are subrecords associated with the record.

I have a relationship established between TicketNum in all three tables. I
have also written a Requery event procedure for both subs on the Activate
event of the main form. No change.

Can anyone give me information on how to solve this problem?
Click to expand...

For the subform, make sure that it's DataEntry property is set to "No".
 
Thank you, Brian. Such a small thing -- but such a big thing!

Brian said:
Susan L said:
I found one post on this issue, but the "poster" did not follow through. I
have a main form and two subforms. In each instance, there is a one-to-many
relationship from main to sub. The Main's primary key is the foreign key in
each of the tables underlying each subform. I have the Master/Child links set
up for the primary/foreign key [TicketNum] and one other field, [State].

When I enter data in the subform it both is visible and is written correctly
to the underlying table, including foreign key and State field values.
However, when I switch off the main record to another one on the main form,
and then return to the one in which I had entered (sub) data, the record(s)
in the subform neither appear -- nor does the record count indicate that
there are subrecords associated with the record.

I have a relationship established between TicketNum in all three tables. I
have also written a Requery event procedure for both subs on the Activate
event of the main form. No change.

Can anyone give me information on how to solve this problem?
Click to expand...

For the subform, make sure that it's DataEntry property is set to "No".
Click to expand...
 
Back
Top