I'm trying to post data to a subform that's located in the Agent Database, from a command button on a database called Login.

When I run this code a blank record and the words "New Task" are placed into the subform. When viewing the subform records from the subform you see the blank record and "New Task". But when I view the parent record "Carol", the "New task" entry does not show in the subform.

What step am I missing?

Thanks for the help.

vRS = @XResultSetSearch(@FN, "Agent", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!Name=Carol")      
     If vRS > -1
     {
           vCRS = @XResultSetSubSet(vRS, "SubForm")
           If vCRS > -1
           {
                 If "Task" <> ""
                {
				XResultSetCreateNewRecord(vCRS)
 				XResultSetValue(vCRS, "Task", "New Task")
                                XResultSetClose(vCRS)
                 }


				 

Morning Erika,

Interestingly enough this has been working:

var vRS as Int
var vCRS as Int


vRS = @XResultSetSearch(@FN, "agent", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!Name=Carol")
If vRS > -1
{
	vCRS = @XResultSetSubSet(vRS, "Subform")
	If vCRS > -1
	{
//XResultSetCreateNewRecord(vCRS)
XResultSetValue(vCRS, "task", "New ttt4432")
//XResultSetReparent(vRS, "agent", vCRS)
	} 

And, I'll use reparent that's commented out too.

You need XResutSetCreateNewRecord and XResultSetReparent. Create the new record, set the values you want in that record, then parent the new record to the correct parent record.

Hello tcgeo,

Try

var vRS as Int
var vCRS as Int


vRS = @XResultSetSearch(@FN, "Agent", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!Name=Carol")
If vRS > -1
{
	vCRS = @XResultSetSubSet(vRS, "Subform")
	If vCRS > -1
	{
		XResultSetCreateNewRecord(vCRS)
		XResultSetValue(vCRS, "task", "New Task")
		XResultSetReparent(vRS, "Subform", vCRS)
		XResultSetClose(vCRS)
	}

	XResultSetClose(vRS)
}
  

-Ray

Hello,

The first problem was not reparenting the newly created record.
Second was reparenting the new record using the wrong field name.
Third was not closing all the result sets.

XResultSetCreateNewRecord will work in any result set but the newly added record will not be parented unless you call XResultSetParent.

-Ray

You are welcome.

-Ray