Go to New Record in subform

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

I posted this in the Forms Programming group, but no
response yet. Maybe this is a better newsgroup for this
question. I have a main Form with two subforms. I want
to add two Command Buttons; one Command Button to go to a
new record in Subform A and the other Command Button to go
to a new record in Subform B. When I try to build a Go To
Record macro, it tells me I am referencing an object that
is not open (I guess that would be the subform). If I
build a macro that first executes the Open Form action to
open the subform, it opens a separate subform rather than
the one embedded in my main form. Maybe I need to program
it in Visual Basic, but I am not sure how to do this.
Basically I am trying to move from the main form to the
first empty row in a subform. Any suggestions?
 
Which version of ACCESS are you using? I have found that ACCESS 2000 is not
good for this type of action; 2002 is better.

Post the exact actions that you're trying to use in the macro. Did you set
"focus" (GoToControl) on the subform before you do the GoToRecord action?
 
Thanks for the info Ken. I am using Access 2000. Someone
responded on the other newsgroup and had the answer for
me. I wasn't treating the subform as a control, like I
should have. I did it in VB, using the following:

DoCmd.GoToControl "subform name"
DoCmd.GoToRecord , , acNewRec

I tried it and it worked!!

Thanks,
Kathy
 
Back
Top