Controlling a form generated by OpenTable or OpenView method

[Yarik]

Hi everyone,

This is about those standard datasheet-view forms that MS Access opens
when DoCmd.OpenTable and DoCmd.OpenView methods are invoked.

I was always wondering: is there any way to get a handle on those
forms once they are opened?

I mean a possibility of writing code like this:

Call DoCmd.OpenView("MyView")
Dim frm as Form: Set frm = GetJustOpenedForm()
frm.Caption = "My Caption" ' Instead of ugly default...

or maybe even catching events from such a form.

Any feedback would be greatly appreciated!

Thanks,
Yarik.

 

[Brendan Reynolds]

Hi everyone,

This is about those standard datasheet-view forms that MS Access opens
when DoCmd.OpenTable and DoCmd.OpenView methods are invoked.

I was always wondering: is there any way to get a handle on those
forms once they are opened?

I mean a possibility of writing code like this:

Call DoCmd.OpenView("MyView")
Dim frm as Form: Set frm = GetJustOpenedForm()
frm.Caption = "My Caption" ' Instead of ugly default...

or maybe even catching events from such a form.

Any feedback would be greatly appreciated!

Thanks,
Yarik.

They're not Access forms, Yarik, so no. They do not expose events, and don't
have a Caption property.

 

[Yarik]

They're not Access forms, Yarik, so no. They do not expose events,

and don't have a Caption property.

That's a shame...

Anyway, thank you much for the quick response, Brendan!