Subforms problems

[janmd]

I created a form using a table as a subform, which worked fine, but I
wanted to add in a calculation, so created a form which I have dragged
on to my main form. It seems to have linked master and child fields
satisfactorily. However, it is not showing any data previously input
to the subtable. What am I doing wrong, please? (apart from probably
being stupid in the original setup!)

 

[Ken Sheridan]

Its difficult to pinpoint the problem at this distance, but the first thing
to check is that when you open your new form, i.e. the one to be used as the
subform, directly from the database window rather than as a subform, it does
return all the data. If not then there is problem with the form itself
unconnected with its use as a subform.

If the new subform can be opened successfully directly, then make sure that
the LinkMasterFields and LinkChildFields properties of the subform control in
the main parent form are correct. The former should be the name of the
primary key column in the parent form's underlying recordset, the latter the
name of the corresponding foreign key column in the subform's underlying
recordset.

If the new subform can be opened successfully directly, do you have a
back-up copy of your file with the original form/subform when it was working
correctly? If so you could copy and paste this from the back-up to your
current file and then change the SourceObject property of the subform control
to the name of the form you now wish to use as the subform.

Ken Sheridan
Stafford, England