How go to new record in subform?

[Guest]

I have a main form containing a subform.
The subform is a continuous form that lists related items.
What I want to be able to do is to click on the label of the subform (on the
main form) and then jump to the new record line of the subform list.
I'm lost on the syntax to do this.
I have been able to get it to position on the first line in the subform but
not the new record line.

 

[kingston via AccessMonster.com]

Try this on the control's .OnClick event:

Me.MainForm.Form!SubForm.Form.Recordset.AddNew

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformReference.mdb" which illustrates how to do this as
well as a number of other things with referencing subforms and subsubforms.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L