| | |
|
|
|
[Repost] Form/Subform question |
|---|
| message from Damien McBain on 6 May 2004 |
Like this:
Territories Customers Sales ProductHierarchy
|
| =?Utf-8?B?SmFja2llIEw=?= replied to Damien McBain on 6 May 2004 |
Damien,
Possibly, this may work in your situation also. Have your calculated field (ActSalePT) hidden. Then on the after update of any of the fields in the formula for ActSalePt you would have
[ActSale]=[ActSalePT]
The bound field (ActSale) would get a new value anytime the factors in the formula for ActSalePT are changed but could still be overwritten if necessary.
This may help eliminate the problem with the visible and hidden fields.
|
| Damien McBain replied to =?Utf-8?B?SmFja2llIEw=?= on 8 May 2004 |
Thanks for the reply Jackie. I've tried that. The problem is that the
subform uses continuous forms and any afterupdate events seem like they
operate on the same field on every form in the subform at the same time.
This confuses the really dumb users (sales reps!) who don't understand the
behavior of Access apps. I need to control the environment more so they
can't break it.
I'm thinking that when one of these calculated ratio type fields is being
editied, I might have to hide all the other forms on the subform by changing
the DefaultView propery in the editable fields.
Back to the drawing board...
Jackie L wrote:
|
| Pieter Wijnen replied to Damien McBain on 6 May 2004 |
What about setting the field's locked property in the on Current Event of
the form
alternatively apply a filter to the form to only display the record to be
updated
HTH
Pieter
"Damien McBain" <ask.me@for.it> wrote in message
news:409a2a58$0$16573$5a62ac22@freenews.iinet.net.au...
|
| Damien McBain replied to Pieter Wijnen on 8 May 2004 |
Thaks Pieter.
I'll try the locking. If I set the OnCurrent event to unlock the field will
that allow all the other individual forms in the subform to remain locked?
As for the filter, I really need all of the records to be visible at once.
It's a customer budgeting tool which selects a customer in the main form
then displays all related product records in the subform. Is I wrote in my
response to Jackie's post, I will try hiding all the other records only when
one of the ratio fields is being edited.
cheers
Pieter Wijnen wrote:
|
|
Archived message: [Repost] Form/Subform question (Microsoft Access Error Message)
