Very Basic Newbie Question

[weefunk]

I know I'm Missing something VERY basic here.
I Recently started learning VB (self-taught with Books CBTS, etc) and
I have a simple project started with ADO bound to fields and even have
all of my EOF & BOF where the stop correctly. The records will display
in the text boxes correctly.

I don't know SQL (will soon) but I just want a simple way to search
the Database I connected to to display that recordset.

I created a search form but have trouble having it come up on my main
form. What am I missing?

 

[Ken Snell]

You should be able to set the form's Recordset property to be equal to the
recordset that you've created.

Set Forms("FormName").Recordset = YourRecordsetName

Note that you cannot close YourRecordsetName recordset while the form is
open, else the form will no longer be able to display that recordset.

 

[weefunk]

Set Forms("FormName").Recordset = YourRecordsetName

Got it...

Thanks Much Ken

 

[Ken Snell]

You're welcome.

Got it...

Thanks Much Ken