DataSheet on Tab Control

[Guest]

To date most data entry screens have been -
frmMain with subfrmDE for data entry and subfrmDS for the datasheet view.
The entry
Set Me.subfrmDE.Form.Recordset = Me.subfrmDS.Form.Recordset
in Form_Load of frmMain has provided the linking.

The current situation is that I need much more real estate and it seems
appropriate to have my first experience with the Tab Control.

This would then mean that the tab pages would contain data entry subforms of
the main data entry form plus the datasheet view.

I can't figure out how to have the datasheet view on a Tab page (and linked
as I have been doing) or, if it is possible.

Thanks

 

[Dirk Goldgar]

To date most data entry screens have been -
frmMain with subfrmDE for data entry and subfrmDS for the datasheet
view. The entry
Set Me.subfrmDE.Form.Recordset = Me.subfrmDS.Form.Recordset
in Form_Load of frmMain has provided the linking.

The current situation is that I need much more real estate and it
seems appropriate to have my first experience with the Tab Control.

This would then mean that the tab pages would contain data entry
subforms of the main data entry form plus the datasheet view.

I can't figure out how to have the datasheet view on a Tab page (and
linked as I have been doing) or, if it is possible.

I haven't tried the linking technique you describe, but I don't see why
the tab control would be a factor at all. Even if one subform is on one
tab page and the other is on another tab page, that has no effect on the
references to the controls. The line

Set Me.subfrmDE.Form.Recordset = Me.subfrmDS.Form.Recordset

should still work. Did you try this and have a problem? Or are you
having a problem actually getting the subforms onto the tab pages?

 

[Guest]

Hi Dirk

My problem is that I am too damned smart! I had thought the process through
and figured that the situations were quite different, but couldn't see far
enough beyond the the end of my nose to actually try it and to therefore find
that it seems to work OK.

Apologies for wasting your time.