When I have a form with subforms and leave the main form to enter the subform is there a mechanism that could execute @save.

In my test application I have a form called basic that contains
Many elements housing Basic information
An invoice subform.
A line items subform.

I have logic that sets the record id in the basic database and adds that id into the invoice database when creating a new invoice and logic that assigns the invoice number  to that invoice and logic that adds that number into an element on the line items subform on each new line item..

My problem is that if I do not save the data immediately before entering the subform my values from the previous part of the form are not available for use in the subform.

I have tried putting @save in numerous spots but I get sporadic results.

My concept works perfect every time if I f10 then f9 and then enter the subform.

All my databases link ok together the big frustration is if I leave f10 un controlled, with auto dating or numbering or any other initial value I end up with tons of junk records. When I use logic like below to control addition of records it makes  saving confusing.

If @update and lastname = ""
then

if not @askuser("Did you want to add a new ","Patient Record","to The System?") then
Resultsetcurrentposition(@resultsetcurrentposition() -1)

or

If @Update and lastname = ""
{
@Msg("Returning you to previous record.")
ResultSetCurrentPosition(@ResultSetCurrentPosition() - 1)
}
I hope this is somewhat clear.

Any thoughts?

Thanks Bharat.

I will hang in there.

Some days are just tougher then others.