It appears that ALL my programming is running 2 or 3 times in the table view subform in the Invoice application from Inside Sesame March edition.

I assume this will happen in all subforms in table view. For example, On element exit program:

If stock no = "100" then writeln("100").

I get 2 writeln windows and one window has 100 written twice!!!

my best guess is becuase of these three lines that grab info from the parent form, then come back to the subform to enter and save the info.

My last LE On element exit prgramming says:

if stock no > "100" then
{
I      = @formfieldvalue("Invoice", "invoice no", 0)
D      = @Formfieldvalue("Invoice", "invoicedate", 0)
P      = @formfieldvalue("invoice", "home phone", 0)
}


I cant figure it out. Can a subform just not handle much programming? I cant even get CreateNewRecord() to start a new record. It seems to save, then goes UP a line, not DOWN!

Frustrating!

Thanks
Steve in Texas

WriteLn in particular may behave strangely from a Table View Subform because of the way it pushes focus around.

So can someone give us some tips on using programming in a subform? It looks as if all programming is run everytime you move from cell to cell in table view.

Is this addresses in the users manual and I overlooked it?

Thanks,
Steve in Texas