Update field value automatically based on subform

S

Sammie

I need to update the value of a field in a query based on the value of a
calculated field on a subform. How can I do it?

Main form and field I want to update: Forms![frmInvoiceForm]![Ex Whse2]
Based on: Shipments basic query

Subform and field: [Invoice Subform].Form![OrderSubtotal]
This field has a calculated control =Sum([ExtendedPrice])
Based on: Invoice details extended query

How can I get the value of [OrderSubtotal] from the subform into the
field [Ex Whse2] on the shipments basic query? I would like it to be
automatic every time the value of OrderSubtotal changes.

Is it possible to do this via a query rather than on a form? In other
words, can I create an expression on Shipments basic query to update the
value of Ex Whse2?

Thanks.
Sammie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Create an S-Curve from Custom Field? 0
Append Crosstab Query to Existing Table 0
Split form 0
Template with fields and premade texts.. 0
Link a text box based on drop down box with four options MS Word 365 0
Task Information Dialog Box not making duration changes to task 0
DLookup in Continuous form 0
Finding the right style field in VBA 0

Top