Toggle Button

[Jenn]

I'm trying to get my toggle button in my subform to
automatically be selected (true) based on certain criteria
in my main form. Also, the subform is from a different
table than the main form, but they are linked. Any ideas?

 

[TC]

*What* criteria in the main form?

TC

 

[Jenn]

Okay, my whole database is linked by a field, called coil
#. It is an alphanumeric field. Every coil has an inbound
weight and an outbound weight. The outbound is subtracted
from the inbound to give me an inventory balance. This
number only shows up on the form, not in any table. I want
the toggle button in my subform to automatically
select "true" when I have an inventory balance.

Any ideas????

 

[TC]

I'm still not sure that I understand what you want. However, you initially
said:

Say your main form was based on a table or query that included two fields
InboundWeight and OutboundWeight.

Say that form had a subform. Code *in that subform* could examine the two
weight fields in the main form, like this:

if parent![InboundWeight] > parent![OutboundWeight] then
' do something.
else
' do something else.
endif

Does that help?

TC