As an ex VB6 programmer, I have now moved on to Access. I understand Forms
and Subforms. But here is what I don't understand: When I create code, I
have to create an ADO connection, a recordset, et al. When I am in code
mode, is there no connection with Access anymore? What am I missing here?

Rich

--
The journey is the reward.

Rich R wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you have an .adp file you'd don't have to create an ADO connection -
the project has CurrentProject.Connection which you can use.

VBA reads data thru Recordsets, DAO or ADO - just as VB did.

Forms, and Reports, have Recordsets based on their RecordSource
property, or, ADO can set a Recordset to a form's/report's Recordset
property (Access 2000 and later versions). For more info read the
Access help on the RecordSource property and Recordset property in Forms
and Reports.

VBA can manipulate data in Form controls and in a form's RecordsetClones
(DAO) or (Recordset.Clones in ADO).

Since Access VBA uses the Access built-in functions I guess you could
say it is still "connected" to Access.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQd9dRoechKqOuFEgEQIY/QCg/29HsWKa7IiGWmxjhEZJLzyB07cAoLws
ub6emQ1BnQ4kQjDOHOJqkN9v
=Gm87
-----END PGP SIGNATURE-----