error 3265 when accessing odbc data source through data control
Quote:
> please help me!!
> i'm trying to access sql server odbc datasource with data control and
> i get a runtime error 3265, item not found in this collection.
> i create a recordset of dynaset type and set the object to
> data control's recordset property like this:
> set ds = db.openrecordset(strSQL, dbopendynaset)
> set data1.recordset = ds <----
> this is where i get the run time error.
> can someone help me, plese??
> thank you,
> chong pil woo
You are probably trying to link databound control (text box?) to
Data1.Recordset, and in properties of that control you specified
non-existing field name. It may even exist in your original table but it
is obviously not returned by your SQL select. This usually happens when
you link controls from development environment and later on decide to
change SQL query or rename some fileds in the database.
Hope this helps (although you probably sorted it yourself by now).
