Need help populating an unbound form with ADO recordset

[SiberBob]

Using MS 2000.

I have an unbound form and I want to populate the controls on that unbound form with data from a recordset in a table in another MDB.

What Refererences do I need to set in the VB Editor.

Can you direct me to a "primer" about how to construct the code to display the data? I want to use ADO and have tried a few iterations but really have no clue what I'm doing. I'd like to try something simple and then expand from there... I think once I get the data to display, I can handle executing sql statements to append, insert, update and such... I just have 0 experience with ADO recordsets.

Thanks,

 

[CautionMP]

SiberBob,
To answer your first question:
[ul][li]Microsoft ActiveX Data Objects X.x Library[/li][/ul]
Choose based on what version is available on your machine(s).

As to where to start, here is a sample and a warning, from the source:[ul]
[li]MS Help and Support
How to bind Microsoft Access forms to ADO recordsets[/li]
[li]MS Knowledge Base:
ACC2000: Forms Based on ADO Recordsets Are Read-Only[/li][/ul]

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[Zion7]

I haven't read CMP's articles, in case this is brought up already, but if not, remember it's not just
a matter of Binding the form, you will need to bind each relevant control.

Maybe CreateControl() may be required?
It's what I use...