Now that Erika has me straightened out on Forms v DBs:

I have a separate database displayed as as a table view on a tab of my main form. I can click on the tab and enter information in the first field, no problem -- all works as expected.

What I would like to do is, as part of an existing command button on the main form, GoTo that field without having to select the tab and selecting the field. 

The above would be in lieu of a popup message box reminding people to select the tab and enter the required information. I could autofill most of it, and more importantly, ensure that they get to where they need to be.

Thanks

The only way I have been able to accomplish that, was to call a macro with @Macro().

In my case, the macro simply contains one click on the table-view subform (in the blank box above the line number, and to the left of the column header names). But, it sounds like your macro will need to first click on the tab that the subform is on first, then click on the subform.

if Category = "Multi"
	{
	@Macro("Data\Click on Transactions Subform.mac")
	} 

BTW...
Attempting to use ThrowFocus(TransactionsSubform) only results in a compile error when opening the form, even though selecting "Test Program" showed no errors in the Program Editor.

NICEBERG wrote on Aug 20^th, 2006 at 6:28pm:


2.0 adds Hide and Reveal events which can tell when you change tab pages. It also includes the ability to switch to a particular tab page in code.