Full Version: New record in subform from main form
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
obaccessed
Is it possible to force a subform to move to a new record using a command button on the main form? My users have an insatiable need to "save" their record on the subform. To simulate that I chose to use a "Save" command on the main form that locks the subform and increases the boarder width so they see something happen when they click it. The new record button on the subform is then inaccessible and they are confused to have to click "Modify" if they want to add a new record since they aren't "modifying" anything.

Any help would be great.

Happy Turkey Day.
Jack Cowley
Me.SubformControlName.SetFocus
DoCmd.GoToRecord, , acNewRec

hth,
Jack
obaccessed
That worked great - Thanks!
Jack Cowley
You're very welcome...

Jack
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.