Subform doesn't allow new records

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 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? I posted this
previously but got no response, so any suggestions are greatly appreciated!
 
K

Kevin

SELECT BidLineItem.ProjectName, BidLineItem.BidNumber,
BidLineItem.RoomNumber, BidLineItem.ItemNumber, BidLineItem.Quantity,
BidLineItem.ProductDescription, BidLineItem.CBDCode, BidLineItem.UnitCost,
BidLineItem.QuoteCost, BidLineItem.UOM, BidLineItem.LineTotalCost,
BidLineItem.Markup, BidLineItem.SellPrice, BidLineItem.Buyout,
BidLineItem.Vendor
FROM BidLineItem;

I feel as though I have my bases covered, but I must be missing something.
I can insert a subdatasheet in the query and add records without any
problems, which has lead me to belive the trouble is with my subform.
Thank you for looking at this!
Kevin
 
K

Kevin

After further review, I realized my error. I had not included "RoomNumber"
in the Link Child Fields & Link Master Fields subform properties. Problem
solved!
 
Top