Paul -

I suggest you abandon macros and instead use programming. Use SelectTreeItem calls. Rehearse the actions you need to perform, using in all cases the menu tree. Then repeat those actions as SelectTreeItem commands.
There are numerous examples here in the forum and more still in Inside Sesame. There's also the Programming Guide.

A restating of the concept.

Note: macros are not now being used, even though they do work.

Open a Form
Retrieve all records
Sort the results
Open a Table View

There is a form open with only command buttons on it.

The command button in this instance opens the desired form using
vMenu = @SelectTreeItem("Hachibur!Forms!Search/Update!Hachibur!HachiburReview")

Now we have a different form open ("HachiburReview") and I would expect that any addtional programming listed for the command button from the default form has stopped since we are now in a different form.

I plan to use the following code when the form "HachiburReview" opens:

var Vaa as INT
var Vab as INT
var Vac as INT
var Vad as INT


If @Update then
{

Vaa = @SelectTreeItem("Search Update Menu!Search Commands!Retrieve New Results (F10)")
Vab = @LoadSortSpec("Hebrew")
Vac = @SelectTreeItem("Search Update Menu!Results Commands!Sort")
Vad = @SelectTreeItem("Search Update Menu!Other Commands!Table View (Shift-F6)")

}

I'm not sure where to place the code.
When the form opens the cursor is not in any element.

Still fooling with this.

On retrieve Spec Open:
does nothing until you press F10

On Form Entry:
Never opens the table

I copied your example and turned off the macroes I was using.

Paul,

Mark had an error in his code. He had the word "Update" included, but it should not be there in the On Retrieve Spec Open event. (It SHOULD be there for the On Form Entry event.)

Replace the corresponding code in the On Retrieve Spec Open event with this:

@SelectTreeItem("Search Menu!Search Commands!Retrieve New Results (F10)") 

Be careful with the On Form Entry event code. You will get yourself into an endless loop if you use it as is. You will need set some condition to make sure the Table View is only launched once during update mode, or you can simply place it in On Retrieve Spec Open event right under the code that retrieves new results. Something like this:

var Vaa as int

  Vaa = @LoadSortSpec("Hebrew")
  Vaa = @SelectTreeItem("Search Menu!Search Commands!Retrieve New Results (F10)")
  Vaa = @SelectTreeItem("Search Update Menu!Other Commands!Table View (Shift-F6)") 

Even though the Table View call appears in the On Retrieve Spec Open event, it doesn't actually fire until after the "F10" call, which means it is called when the first record in the result set appears.

This should get you up and running. I just tested it here in version 1.1.2, and it works.

Thanks to Carl & Mark.

That was the solution.