Access Macro - What's happening??!

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Diane Herron

Thread Starter
Joined
Dec 28, 2000
Messages
81
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?
 

Attachments

Joined
Dec 13, 2002
Messages
45
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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Members online

Top