DB and recordset names?

  • Thread starter Thread starter Adrian Parker
  • Start date Start date
A

Adrian Parker

When I create a Form using a wizard, what value does the Name property get
for the DB connection, and the recordset?

I want to do something like:
Recordset.AddNew
So when the form opens, it'll start on a new record. But I do not know the
name of the Recordset object so that I can refer to it's methods.

Same with the Connection variable. What name is given to this object? How
do you find this out?

I've searched good without luck.



Adrian
 
DoCmd.GoToRecord acDataForm, Me.Name, acNewRec

will cause the form to go to a new record. You can also refer to the form's
recordset with Me.Recordset.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

recordset vs collection 2
Loading recordset at runtime 4
Dynamic recordset 38
Help with VBScript/Access database 0
Changing font in rich text table 4
Reusable Form & Code 2
recordset values displaying only *one* value on form 7
Access 2007 Tabbed form with shared recordset 0

Back
Top