By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,880 Members | 1,416 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,880 IT Pros & Developers. It's quick & easy.

Recordset Property in subforms

P: 5
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
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?
Sep 23 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 2,653
Hello, Myom.

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

Sep 23 '08 #2

Expert Mod 15k+
P: 31,758
I believe Global is simply the earlier form of Public. Don't worry about changing it ;)
Sep 23 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.