Subform double click on a row?

  • Thread starter Thread starter Stephen Russell
  • Start date Start date
S

Stephen Russell

I'm helping out another friend and Access isn't my strong point :)

Subform is created with a query of 50 columns out of a "property locations"
table. Subform shows only 10 columns defined out of the 50, and they are
stacked up. When form runs Access does a cross tab in it's display and
shows a grid. I'm cool with that.

How can I catch a double click on the row in that grid, and show a different
page in the pageframe control for the main form that this subform is a part
of.

Main is a form that uses a pageframe control to separate 10 pages of
activity for the entire application. This subform is on the initial page,
or the left most tab is highlighted.

TIA

__Stephen
 
Hi Stephen,

By "grid" I guess you mean that the subform is set to open in Datasheet
view. If so, each column corresponds to a control, probably a textbox,
on the form. Close the form and open the subform alone in design view
and you'll see them. Use the form's property sheet to set their
OnDoubleClick properties to [Event Procedure].

Is a "pageframe control" the widget that Access calls a tab control? If
so, you move from page to page by adjusting the Value property of the
control.

When code running behind the subform needs to refer to controls on the
parent form, you can use syntax like this:

Me.Parent.Controls("MyTabControl").Value = 3

or the more cryptic

Me.Parent!MyTabControl = 3
 
John Nurick said:
Hi Stephen,

By "grid" I guess you mean that the subform is set to open in Datasheet
view. If so, each column corresponds to a control, probably a textbox,
on the form. Close the form and open the subform alone in design view
and you'll see them. Use the form's property sheet to set their
OnDoubleClick properties to [Event Procedure].

Is a "pageframe control" the widget that Access calls a tab control? If
so, you move from page to page by adjusting the Value property of the
control.

When code running behind the subform needs to refer to controls on the
parent form, you can use syntax like this:

Me.Parent.Controls("MyTabControl").Value = 3

or the more cryptic

Me.Parent!MyTabControl = 3
Click to expand...

Thanks. I should be able to put them in. Sorry that I'm using terms form
my C# work, I get in a situation and can't find and answer because access
calls it a different name :(
 
Back
Top