change from version 1 to version 2 using FormCommit() solved the problem

when i call the @formresultsettotal in a new window (no data insertet) the result is 0
so i inserted the code if vn1 = 0...
but when i use @formnewrecord("Artikelliste") then vn2 also gets to 0 so there is no chance to get a higer number (new records to post in)! also @formresultsettotal is 0 until i switch to the subform and back then the @formresultsettotal changes into 1

			vn1 = @formresultsettotal("Artikelliste")
			if vn1 = 0 then
			{
				vn1 = 1
			}
			vn2 = @tn(@formfieldvalue("Artikelliste", "Menge", vn1))

			if vn2 <> 0 then
			{
				 vn2 = @formnewrecord("Artikelliste")
				 vn1 = vn2
			}
 

i give a better example:

a database with 2 fields (test1, test2) and a subform with 1 field(text1)

the programming for test1:

var vn1 as int
var i as int
var input as string

subroutine writesub()

vn1=@formresultsettotal("sub")
if vn1 = 0 then
vn1 = 1

input = test1

i = @formnewrecord("sub")
formfieldvalue("sub","text1",vn1,input)


end subroutine

writesub()
test1="" 

programming for test2:

goto test1 

subform has no programming

there the data is always writen in the first line of the subform!! why??? the formresultsettotal shuld give back a higher number to write in!

but when i need to know how many records are in the subform. the program i posted is a simple test application the real one is a bit biger and there i need to know how many recrods are in the subform

i allready used a formthrowfocus() to change to the sub and in the sub a formthrowfocus() to go back.
then the @formresultsettotal is ok but this was just in the test application in the real one this wont work.

is there a simple way to get the @formresultsettotal() to work?

Quote:


@SelectTreeItem() does not prevent programming from running nor does it stop the current event while it is running. It does move the cursor up to the Record Counter however same as the Menu Tree Option does.

If you wish to save the record without the cursor moving to the Record Counter then use FormCommit(). The order you will want to do the commits in is the subs first and then the parent form.

FormCommit("Sub")
FormCommit("Parent") 

-Ray