K
Kevin
I have a subform of a subform in which I get an error 3201 "...cannot add a
record because a related record is required in table..."
The first subform record source is a tblItem, and the second subform's
record source is qryBidLineItem. There are four fields that are Master/Child
fields: ProjectName, BidNumber, RoomNumber, ItemNumber.
When I unhide the related columns, and add a new record to the second
subform, 3 of the fields automatically repeat the common data, but one field,
RoomNumber, does not. So when I try to exit the record, I get this error
message. How do I fix this...or where do I start looking?
record because a related record is required in table..."
The first subform record source is a tblItem, and the second subform's
record source is qryBidLineItem. There are four fields that are Master/Child
fields: ProjectName, BidNumber, RoomNumber, ItemNumber.
When I unhide the related columns, and add a new record to the second
subform, 3 of the fields automatically repeat the common data, but one field,
RoomNumber, does not. So when I try to exit the record, I get this error
message. How do I fix this...or where do I start looking?