Subform new record setfocus

C

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
 
G

Guest

Hi, Candiz.

Try:

Me!YourSubFormName.SetFocus
DoCmd.GoToRecord , , acNewRec

HTH
Sprinks
 

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

Subform new record setfocus 1
Combo box referencing parent form and sibling subform? 5
Set Change Event on Control from Nested Subform 0
MainForm, SubForm and SubSubForm 7
Set focus in a specific record within a subform 1
data entry in subform before mainform causes huge hassle, HELP! 2
Testing for NewRecord on subform 1
Counting in Subform 3

Top