Form and Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two quirky errors; don't know if they're related or not.

1 - have 'add record' button on form. when clicked, correct form opens, but
not to new record. I have to click * button to get to new record. Here's
code, pretty straightforward:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "FrmContacts"
DoCmd.GoToRecord , , acNewRec

DoCmd.OpenForm stDocName, , , stLinkCriteria

2 - When in 'frmContacts' and adding new data to subform, subform appears to
jump to next new record when I try to tab (exit) out of the subform. Can
only see what I just input by exiting form and then coming back in again.

Thanks for your help.
Pat
 
pattylb said:
I have two quirky errors; don't know if they're related or not.

1 - have 'add record' button on form. when clicked, correct form
opens, but not to new record. I have to click * button to get to new
record. Here's code, pretty straightforward:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "FrmContacts"
DoCmd.GoToRecord , , acNewRec
Click to expand...

Here you are asking to go to a new record in the CURRENT form.
DoCmd.OpenForm stDocName, , , stLinkCriteria
Click to expand...

Now you are opening the form where you want to enter a new record (see the
problem?)

The OpenForm method has an argument that will open the form in DataEntry
mode (at a new record).

DoCmd.OpenForm "FormName",,,,acFormAdd
 
Thanks for your help.

So my code was redundant? I'll have to play with it because I just don't
quite see it.

But your solution worked well, and it seems neater.

Thanks again.
 
Back
Top