I'm trying to open a second file within my data base while working in a file.  I can open the second file OK using

vMenu = @SelectTreeItem(@Application + "!Forms!Search/Update!NEWPROCS!WORK INSTRUCTIONS")

with a command button.  When the second file opens it is at the Retrieve Spec.  I'd like to bypass the need to enter the Retrieve Spec and go directly to the second file based on the entry in an element in the first file.

Is that possible?

Any help would be appreciated.

NH User

Hi Paul,

As long as you are on 2.6.4, an earlier version had an issue with this, you can do this with XResultSetOpenForm(). The example below opens the Customers form to the record that has the ID of 1000.

Var vRS as Int

vRS = @XResultSetSearch(@FN, "Customers", 0, 2, "!Key=1000")
If vRS >= 0 Then
{
	If @XResultSetTotal(vRS) > 0 Then
	{
		XResultSetOpenForm(vRS, "Customers")
	}
	XResultSetClose(vRS)
} 

-Ray