Update data across linked fields in form/subform

[Guest]

Using Access 2000...

I have a main form which includes "lot" and "wafer" fields (from table "lot
info"), then a subform with both "lot" and "wafer" as well, but they are from
table "stress test" (can have multiple entries on "stress test" by single lot
and wafer).

I've linked both "lot" and "wafer" across the forms, but when I update the
lot or wafer name in the main form, the subform DOES NOT update, and instead
displays a blank form.

 

[John Vinson]

Using Access 2000...

I have a main form which includes "lot" and "wafer" fields (from table "lot
info"), then a subform with both "lot" and "wafer" as well, but they are from
table "stress test" (can have multiple entries on "stress test" by single lot
and wafer).

I've linked both "lot" and "wafer" across the forms, but when I update the
lot or wafer name in the main form, the subform DOES NOT update, and instead
displays a blank form.

How did you "link" them? I'd expect that the Master and Child Link
Field properties of the Subform control should be

[Lot];[Wafer]

The subform will display existing Stress Test records for that
combination, if there are such records; if there are not, then entring
data into any of the (blank) other fields in the subform should cause
the Lot and Wafer values to fill in. Ordinarily these fields would not
be displayed on the subform (since you can see them on the mainform)
but that's your choice.

John W. Vinson[MVP]