Thanx guys! I really did not intend to test your mind reading skills. You are great!

I am really trying to figure it out myself for now:o
but don't let that stop anyone from pointing out fatal flaws or outright mistakes, or helpful hints or....really anything.
(I just HATE not knowing what I am doing most of the time and bugging everyone about things I should probably know by now or could find myself if I just searched for the right thing. Programming is about 10% of this job and I work about 10hrs a week here so I forget stuff from week-to-week.)
I feel better now, please just e-mail the bills for psychoanalysis

MySubform: le44
MySubformLE(that cannot be blank to add): ticket_number
_________________________________
var nn as int

if @FormFieldValue("le44", "Ticket_number", 0) <> ""  //Check if subform LE is not blank
{
nn = @FormNewRecord("le44")
//FormFieldValue("le44", "ticket_number", nn, MyValue)  //Post to new subform record. nn is the subform instance created above.
}

_________________________________

(I "//" the FormFieldValue line because I already have it set up to fill all the name & address fields when the subform is entered. If this adversely affects things because I mis-understood the purpose let me know. )

I am sincerely considering changing my name to clueless in Louisville...

Oh, and
Happy Holidays !!  2

Aaaaaaaaaaaahhhhh!!!!!

Drunk rat!!!!!!!!!!!!!!!!

Running away now...

Quote:


CreateNewRecord() was replaced by @CreateNewRecord()

-Ray

Capt'n,

Don't be afraid of subforms. They are one of the best features that Sesame has. Almost every one of my apps use table-view subforms.

There were a few hiccups with them in previous versions, but 1.1.3 has take care of them.