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
 
S

Sprinks

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

Populate main form from subform record 0
Subform new record setfocus 1
Unremovable horizontal scroll bar on subform 1
defaulting subform values to mainform's prior records 1
Set focus in a specific record within a subform 1
Combo box referencing parent form and sibling subform? 5
data entry in subform before mainform causes huge hassle, HELP! 2
Dynamic Naming of Form Button 3

Top