where is the error???  Ok, I give up. I fully expect to feel like a fool once this is answered but at least my button will work:-[

Le44 is the field that needs to  not* be blank before adding the record. The book had Add1 which I "assumed" was a generic field name so I changed it to mine. The button's name is Ticket.
************************************

If(Le44 <> "")


{

          CreateNewRecord()

}


____________________________________
Error String
Error while parsing module "Ticket(0)":
Symbol expected [}], symbol found [Identifier].
Line 11, position 9: [Identifier: CreateNewRecord]
CreateNewRecord()
             ^

**********************

I spent most of the day on this one thing & have gotten nowhere.  Please put me out of my misery. (Unfortunately I am leaving so will not find out till Sunday at the earliest)

~Natalie

*Added the "not" to clarify for anyone else who came along. I forgot it first time, much to my embaressment

Quote:


Try this:
========================
var vOK as Int

If @IsBlank(Le44)  Then {
          vOK = @CreateNewRecord()
          }

========================

I see what Mark meant, now.

I just did some testing, and CreateNewRecord() (the one without the "@" symbol) does not seem to be a valid command or function in the latest release.

Quote:

Hmmm. Well, I guess you understood her intentions, while I was strictly looking at the code. ???

Quote:

I agreed with you, that she should use @IsBlank instead of <>"", I was just pointing out that (I thought) she needed to include "Not" before it.

Carl, you may be right, but I read the intention vs. the code. I did the same as you the first time I looked at this, then did a reread, and thought the code was wrong from the beginning.

The intent is usually more correct than the code, right?  That is why we usually end up debugging the code.

On Monday, natalie will clarify this for us.

I intend to pay more attention. Scouts honor!

I actually DID want le44 to not be blank.  (That was apparently the only thing I got right)

I will not be back on till Friday. I will closely examine the situation and ask a coherent question then.

Briefly, what I am trying to ad is a subform and the field that needs to be not blank is on the subform. To really make it a mare's nest, I had somehow gotten the subform and the field I need to not be blank to have the same name. (My 8th grade english teacher is spinning in her grave after THAT sentence structure)

I did get it to ad a form thank you very much. It added the parent form of course. I saw a few other comands specific to subforms and I will investigate them Friday.

Thanx again
~Natalie
(sleep deprived again and it shows )

Natalie,

Bob is correct, "we are working at the wrong level of forms".

To add a new record to a subform, you need to use @FormNewRecord("MySubform") rather than @CreateNewRecord().

To check the content of a LE in a subform, you need to use @FormFieldValue("MySubform", "MySubformLE", SubformInstance).

Based on what I believe you are asking, this is the general structure you probably need to use:

var nn as int

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

The last line demonstrates how you would post data to the subform record. It will post a value to the newly created record.

You also need to figure out which instance of subform to check, for the blank LE. If you simply need to check the last one, you can use @FormResultSetTotal("MySubform") to find it.

------------------------------------------------------------------------

The previous info is based on what I first thought you asked for. But, it also sounds like you may want to use the following code instead. It will add a new subform record every time you click on the Ticket button, except when you don't have any subform data yet (like when the parent is new). It will check the first subform instance to see if it is blank. If it is blank, it will add the data to that first subform record. Otherwise, it will add a new subform record, and post the data to the new one.

var nn as int

if @FormFieldValue("MySubform", "MySubformLE", 1) <> ""
	nn = @FormNewRecord("MySubform")
else
	nn = 1

FormFieldValue("MySubform", "MySubformLE", nn, MyValue)
 

This is actual code that I am using in one of my apps.

@IsBlank does not work for subforms when the code that is running is in the parent form. (Or at least that seems to be what I remember finding out.)