Form Refresh Issue

[JeffChr]

This is a bit unusual I think. I have two related forms. The second form is opened in dialog mode with a button from the first.



Code execution stops in the first form after the open statement for the second form until the second form is closed.

The second form modifies the same record that is current on form 1.

After form 2 closes, form 1 executes a refresh, so it is populated with form 2 updates.

When I try to do calculations on these new updated field values in form 1 they fail unless I pause the VBA code with a msgbox prior to performing calcs after the refresh.

Wild ! Anyone ? Thanks in advance for your assistance.

[qa12dx]

form 2;
set tempvar to id rec on form1
close form2
applyfilter form1.id=tempvar
requery
do calcs
remove tempvar

[JeffChr]

form 2;
set tempvar to id rec on form1
close form2
applyfilter form1.id=tempvar
requery
do calcs
remove tempvar

Ahh, yes you are correct. I couldn't figure this one out so I turned on "break on all errors" and then started receiving EC 7878. I don't know why I wasn't receiving this message prior to the options change since I was not trapping errors anywhere in my code. whatever.

you are correct. I should have realized what was going on.

i ended up just changing form 1 from form 2 and using just the one dataset which solved my problem. THANKS !