Update field on main form when all fields on subform are complete

N

Nancy

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!
 
B

Beetle

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.
 
N

Nancy

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 said:
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 said:
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!
Click to expand...
Click to expand...
 
Top