Recordset property in Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tik Sin - 25 Nov 2003 04:13 GMT

I want to create a Form automatically with VBA. I have
succeeded to create a new Form and create controls. But
if I want to fill in the Recordset property (Set
NewForm.Recordset = rstRecordSet), I get the error
message that an object is not open or does not exist.
When i open the form first (with DoCmd OpenForm), I still
get the same error. The recordset rstRecordset is open.

any ideas? thanks,
TS

Reply to this Message

TC - 25 Nov 2003 02:49 GMT

What version of Access?

A97 & below do not have a Recordset property of the form object.

HTH,
TC

> I want to create a Form automatically with VBA. I have
> succeeded to create a new Form and create controls. But
[quoted text clipped - 6 lines]
> any ideas? thanks,
> TS

Reply to this Message

Tik Sin - 26 Nov 2003 00:22 GMT

I use: Access 2002 SP-2
TS

>-----Original Message-----
>What version of Access?
[quoted text clipped - 16 lines]
>
>.

Reply to this Message

TC - 26 Nov 2003 01:36 GMT

Ok. I don't have A2002 here to check, so this is a guess. I'm guessing that
you can not assign a persistent recordset to a form. The recordset is
generated at runtime, based on the form's rowsource & other attributes. So
although you >can< assign a rowsource at design time, I suspect you >can't<
assign the recordset at design time.

As I say - just my guess.

HTH,
TC

> I use: Access 2002 SP-2
> TS
[quoted text clipped - 24 lines]
> >
> >.

Reply to this Message

Elite IT - 07 Sep 2007 21:49 GMT

Is there an affiliate program for Microsoft for businesses to join?

Signature

Nishan Kumaraperu
Elite IT Appleton WI
http://www.eliteitpc.com

Reply to this Message