Limiting subform to single record

[natalie]

I have a data entry subform that I want to keep, basically, as a single form:
no multiple records within the subform.

I managed to do this however, I would like for the final "tab" to open up a
fresh main form. Right now it just keeps tabbing through the subform over
and over.

 

[Steve Schapel]

Natalie,

You will need to use code to achieve this. I expect, whithoiut testing,
that you could use the Exit event of the last control on your subform.
When you say "open up a fresh main form", I suspect what you really mean
is go to a new record on the main form... am I right? If so, the code
will be like this:
Me.Parent.Form![NameOfA ControlOnTheMainForm].SetFocus
DoCmd.GoToRecord , , acNewRec

 

[natalie]

Thank you. I greatly appreciate your help.

Natalie,

You will need to use code to achieve this. I expect, whithoiut testing,
that you could use the Exit event of the last control on your subform.
When you say "open up a fresh main form", I suspect what you really mean
is go to a new record on the main form... am I right? If so, the code
will be like this:
Me.Parent.Form![NameOfA ControlOnTheMainForm].SetFocus
DoCmd.GoToRecord , , acNewRec

--
Steve Schapel, Microsoft Access MVP

I have a data entry subform that I want to keep, basically, as a single form:
no multiple records within the subform.

I managed to do this however, I would like for the final "tab" to open up a
fresh main form. Right now it just keeps tabbing through the subform over
and over.