Where (which subroutine .etc) do I set the recordset and connection, so that I'll be able to access the database throughout the forms?

I had tried to put the statement in form_activate, but I couldn't access the database in another subroutine.

I need to assign a string with my database field.

dim sName as String
sName = adoStudent!Name

can this be done?

TIA