1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access Macro - What's happening??!

Discussion in 'Business Applications' started by Diane Herron, Jan 22, 2003.

Thread Status:
Not open for further replies.
  1. Diane Herron

    Diane Herron Thread Starter

    Dec 28, 2000
    I have a subform attached to a form. On the subform I am using a macro (Before Update event) where the action is SetValue, the Item is [CoBorGrossMoInc], and the Expression is [Forms]![frmCo-BorrowerInfo]![CoGrossMoIncCalc]. I get the error message shown on the attached file when I close the main form or go to the next form. The macro does work when the subform is open at the same time as the form.

    Is there a way to get the macro to work without having the subform open?

    Attached Files:

  2. kbstoikop


    Dec 13, 2002
    it is a little confusing because a subform is usally embedded in the main form.

    The best way to update fields in a form is to create a hidden field on the main form and update the subform based on the field value of the main form. Since the main form should always be open the field should get the correct value.

    also you should use accessvb to update things instead of macros as the macros can be limiting in what you can do
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/114654

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice