Open subform on Tab Form, with criteria

[Annette Massie]

I have a form (frmMainForm) that has a tab control (frmTab). This tab
control has 4 pages. Each page has a subform on it.

I am in the first tab's subform and in a listbox. I want to double
click an item in the list box and have it go to that record that is on
the 3rd tab's subform. The third tab is called Equipment Tab and the
form is called frmEquipment.

I can't figure out how to open frmEquipment, passing the criteria from
the first form's subform. When I do docmd.openform "frmEquipment", it
opens that form solo and not within the tab's subform.

Any suggestions?

[Rick Brandt]

"Annette Massie" <an******@co.saint-croix.wi.us> wrote in message
news:c6**************************@posting.google.c om...

I have a form (frmMainForm) that has a tab control (frmTab). This tab
control has 4 pages. Each page has a subform on it.

I am in the first tab's subform and in a listbox. I want to double
click an item in the list box and have it go to that record that is on
the 3rd tab's subform. The third tab is called Equipment Tab and the
form is called frmEquipment.

I can't figure out how to open frmEquipment, passing the criteria from
the first form's subform. When I do docmd.openform "frmEquipment", it
opens that form solo and not within the tab's subform.

Any suggestions?

Me.TabControl.Value = 2
Me.SubformControlName.Form.Filter = "SomeField = " & Me.SomeField
Me.SubformControlName.Form.FilterOn = True
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com