G
Guest
I have a subform that calculates some values based on the main form. The
main form is a continuous form, and each record has a combobox and a couple
text boxes. What I want is for my subform to be recalculated based on the
value of the combobox of the active record on the main form.
Now, the subform is linked to the main form based on that value, and it
works fine if I simply select a record on the main form. However, if I
select a new value in the combobox and then tab to the next control, the
subform does not recalculate. This happens even though I have added a
requery statement for the subform in both the afterupdate and change events
for the combobox.
Is there some way to make this work? Seems like it's not working because
the active record hasn't been saved yet, so it still sees the old value. How
to i force the record to save when i tab off of the combobox?
main form is a continuous form, and each record has a combobox and a couple
text boxes. What I want is for my subform to be recalculated based on the
value of the combobox of the active record on the main form.
Now, the subform is linked to the main form based on that value, and it
works fine if I simply select a record on the main form. However, if I
select a new value in the combobox and then tab to the next control, the
subform does not recalculate. This happens even though I have added a
requery statement for the subform in both the afterupdate and change events
for the combobox.
Is there some way to make this work? Seems like it's not working because
the active record hasn't been saved yet, so it still sees the old value. How
to i force the record to save when i tab off of the combobox?