×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Updating a main form field from an unbound sub-form field

Updating a main form field from an unbound sub-form field

Updating a main form field from an unbound sub-form field

(OP)
Hi,

I have a main form listing items with quantities, and a sub-form that lists the transactions that make up the quantities for the corresponding item. On the sub-form a user changes the quantity in a field, and this sets a value in another field to the difference between the original quantity and the new quantity. Once the record is saved, then an unbound text box in the header of the sub-form recalculates and displays the sum quantity.

Now, I need to update the quantity field in the main form with this revised sum quantity appearing in the sub-form header. How can do this? I have tried an update query, added to the macro which sets the value and saves the record, but when it goes to run, the unbound field containing the sum has yet to display the new figure and therefore updates the main form with the previous value.

How can I time this, so the unbound field has displayed the new value for the main form field to be updated correctly?

Thank you,
LP

RE: Updating a main form field from an unbound sub-form field

In the textbox control on your main form, set the Control Source, to the textbox control on your subform.

It will look something like this, in the main form's text box Control Source property:

CODE

=[frmSubForm].[Form]![txtCalcControl] 

misscrf

It is never too late to become what you could have been ~ George Eliot

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close