How to tie a record set to a form at run time?

[Ben]

Hi all,

I have at run time a recordset that I want to tie to a form. Currently, I
create a query def at run time and actually create a new query and then have
the form tie to the query. But this is creating more wrinkles than I would
like.

Because I would like to disconnect the recordset (ADO) at run time so that
the user can view/edit/add/delete the recordset and then reconnect and update
the actual table. Can you share some suggestions?

Thank you.

Ben


--

 

[Douglas J. Steele]

You can create the recordset and assign the form's Recordset property to
that recordset.

 

[Ben]

Doug,

Are you referring to the "record source" on the Data tab? when i click on
it, it takes me to the query builder. Please clarify for me.

Thanks,

Ben

 

[Douglas J. Steele]

No, I meant the Recordset property:

http://msdn.microsoft.com/en-us/library/aa217496(office.10).aspx

Hopefully you're using Access 2002 or newer.

 

[Ben]

I see. Thanks Doug.

Ben

--

No, I meant the Recordset property:

http://msdn.microsoft.com/en-us/library/aa217496(office.10).aspx

Hopefully you're using Access 2002 or newer.