Recordset Property in subforms

[MayoM]

The help on "Recordset Property" describes how you can bind a form to a recordset.

I am trying to get this to work
- in Access 2003
- in a subform
- in the Form_Open event
- assigning a recordset I have opened in the main form (and which is not the main form's recordset)

The help implies that I need to make the recordset a global. But this is causing problems

If I change
Public rs as ADODB.Recordset
to
Global rs as ADODB.Recordset

I get a compile error "Constants, .... not allowed in Public members of object modules"

Any ideas on what the answer is?

[FishVal]

Hello, Myom.

You may read the thread dealing with form's recordset.

Regards,
Fish

[NeoPa]

I believe Global is simply the earlier form of Public. Don't worry about changing it ;)