go to a new record in a subfrom from a third form

C

Chris

Helle everyone,

I have the following situation: I have a form (form1 - more or less an
overview form) from which I want to open another form (form2), which has a
subform (form3).
I open form2 from form1, filter the records, and immediately skip to a new
record in form3 within the filtered records. I'm not sure how to do that and
right now I'm stuck just filtering the records, since I cannot find a way to
reference form3 from form1's DoCmd.GotoRecord.

Any help is greatly appreciated

Cheers

Chris
 
O

Ofer

On the onload event of form2 write the code

Me.Form3SubName.SetFocus
DoCmd.GoToRecord , , acNewRec
 

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

Open Form unfiltered 2
how to create a "link" in word 2007 without using "hyperlink"? 1
Unbound listbox in Continous Form 3
Requery, but return to the current record 3
Update queries with form (trying to avoid error) 1
How to Import Formatted text as new Slides in PowerPoint 0
open form to specific record number 5
Go to a new record on another form? 6

Top