form/subform

[Tom]

I'm trying to get a child linking subform to take order
info ie. (price for standard and price for replacement
which is used to generate the price charged based on a
yes/no field in the subform line)from the main form but
the subform can't find the order number in the TBL-Orders
so it will not allow me to enter data because of error
#3101 entering data in the many side of a one to many
relationship. How can I get the order form to update the
table before going into the subform. Or is this not
possible.

 

[John Vinson]

How can I get the order form to update the
table before going into the subform. Or is this not
possible.

What is the subform a subform OF? Typically one would enter the Order
on the main form, and this information on the subform, using the
OrderID as the master/child link field. Access will save the mainform
record the instant you set focus to the subform - no code needed.