How do I force/run an object property

[Capt James Cook]

I have a form where users enter an item number to look up what size box
(sm/med/lg, etc) in which to pack it. Then they hit the search button which
opens another form. The second form is based on a "containers" table which
contains the item part number and a container part number. The container
table has fields for length, width, & depth but the data is incomplete.
Users can enter new/corrected dimensions and click the "Calculate Size"
button which makes visible a label "Small", "Med", etc and associated packing
costs. This all works fine.

I would like to check if Length+width+depth is > 0 when the second form is
displayed and if so, automatically run the "CalculateSize_Click()" subroutine.

How can I call a subroutine on a form object?
Thanks

 

[ErezM via AccessMonster.com]

hi
it's almost like you wrote here. use the second's form Load event to check
for it,

If Length+width+depth > 0 Then
CalculateSize_Click()
End If

that's assuming Length and width and depth are bound controls on that form
and the button is too.

good luck
Erez