Update field on main form when all fields on subform are complete Nancy 11/15/2008 2:48:01 PM I have a "quote" form with a subform "product" which contains multiple product line items. Each "product" quoted has a "completed date" field because not all products are quoted at the same time. I want to update the main form (quote) "quote date" field when all of the table (product) "completed date"s have been entered. The "quote date" field must equal the last "completed date" from the "product" line item. Your help will be greatly appreciated! -- Nancy

RE: Update field on main form when all fields on subform are complete Beetle 11/15/2008 5:16:01 PM Assuming the link between the tables is, say, QuoteID, you could put something like this in the control source of an unbound text box on your main form; =DMax("CompletedDate", "tblProducts", "QuoteID=" & [QuoteID]) using your own table and field names of course. -- _________ Sean Bailey "Nancy" wrote: [Quoted Text] > I have a "quote" form with a subform "product" which contains multiple > product line items. Each "product" quoted has a "completed date" field > because not all products are quoted at the same time. I want to update the > main form (quote) "quote date" field when all of the table (product) > "completed date"s have been entered. The "quote date" field must equal the > last "completed date" from the "product" line item. > > Your help will be greatly appreciated! > -- > Nancy

RE: Update field on main form when all fields on subform are compl Nancy 11/29/2008 12:30:01 AM Thank you Beetle. I have the unbound field working properly but how do I save this unbound text box in the Quote date field? -- Nancy "Beetle" wrote: [Quoted Text] > Assuming the link between the tables is, say, QuoteID, you could put > something like this in the control source of an unbound text box > on your main form; > > =DMax("CompletedDate", "tblProducts", "QuoteID=" & [QuoteID]) > > using your own table and field names of course. > -- > _________ > > Sean Bailey > > > "Nancy" wrote: > > > I have a "quote" form with a subform "product" which contains multiple > > product line items. Each "product" quoted has a "completed date" field > > because not all products are quoted at the same time. I want to update the > > main form (quote) "quote date" field when all of the table (product) > > "completed date"s have been entered. The "quote date" field must equal the > > last "completed date" from the "product" line item. > > > > Your help will be greatly appreciated! > > -- > > Nancy