Master/Child Link problem

[Beeyen]

Good Day,

I have a database with a mainform and 5 subforms with tabs. I enter
information into the mainform, then the subforms (mainly date information), I
then save, everything looks normal. But when I go back to the record the
mainform information appears but the Subform information is gone.

When I do a Subform link it shows the following message "Result tblRouting
for each record is tblWorkload Information Tracker using DatatrakNumber".

The subform information is populating the tables but not saving to the
records. Would you happen to know what I have setup in error or is there a
way to force the links?

 

[John W. Vinson]

Good Day,

I have a database with a mainform and 5 subforms with tabs. I enter
information into the mainform, then the subforms (mainly date information), I
then save, everything looks normal. But when I go back to the record the
mainform information appears but the Subform information is gone.

When I do a Subform link it shows the following message "Result tblRouting
for each record is tblWorkload Information Tracker using DatatrakNumber".

The subform information is populating the tables but not saving to the
records. Would you happen to know what I have setup in error or is there a
way to force the links?

What do you mean by "populating the tables but not saving in the records"? The
tables ARE the records!! If you look at the table datasheet is the information
there?

I suspect the master/child link field isn't the problem. Do you perhaps have
the Data Entry property set to Yes on the subform? If so it will let you enter
new records but not see old ones.

If that's not it please post the SQL view of the affected subform's
Recordsource property (the table fields if it's a table rather than a query).

 

[John W. Vinson]

Good Day,

I have a database with a mainform and 5 subforms with tabs. I enter
information into the mainform, then the subforms (mainly date information), I
then save, everything looks normal. But when I go back to the record the
mainform information appears but the Subform information is gone.

When I do a Subform link it shows the following message "Result tblRouting
for each record is tblWorkload Information Tracker using DatatrakNumber".

The subform information is populating the tables but not saving to the
records. Would you happen to know what I have setup in error or is there a
way to force the links?

Beeyen, you sent me a private email but your reply address is bouncing.

I'd much prefer to keep the discussion in the newsgroups but if you do want to
contact me offline you'll need to send a working address.