populate form with recordset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

smk23 - 18 Jan 2006 23:46 GMT

I am trying to populate a form with an ADODB recordset using code supplied
here:
http://support.microsoft.com/?kbid=281998

but I get an error "operation is not allowed when object is open" when
trying to open the form. The code is set to run on the OnOpen event as
indicated in the example code. Should I run it on a different event?
Thanks,

Signature

sam

Reply to this Message

Ofer - 19 Jan 2006 00:20 GMT

I tried the code, with and without a sub form, it run fine.

Are you sure it happen in the Sub?
Do you have anything else in the OnLoad event for example, that migt cause
this error?
Put a code break in the first line (press F9) and step through the code (F8)
and see in which line this error happen.

Signature

\\// Live Long and Prosper \\//
BS"D

> I am trying to populate a form with an ADODB recordset using code supplied
> here:
[quoted text clipped - 4 lines]
> indicated in the example code. Should I run it on a different event?
> Thanks,

Reply to this Message