Subform new record setfocus

[Candiz]

I have a mainform, subform and a subsubform within the subform. The
mainform has a one to many relationship to the subform
and subform one to many relationship to the subsubform. I need a command
button to add a new record to the subform to an
existing record on the mainform. I am able to setfocus on the subform but
my problem is I'm not able to reset the subform for a
new record when the button is clicked. I am new to Access VB. I appreciate
any assisance from the experts. Thanks in advance.

Canice

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.co), is a small Access sample
database called: "SubformReference.mdb" which illustrates how to reference,
set focus, and many other things on both subforms and subsubforms.

--
--Roger Carlson
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