UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> New record in subform from main form    
 
   
obaccessed
post Nov 25 2004, 10:31 AM
Post #1

UtterAccess Member
Posts: 21
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.
Go to the top of the page
 
+
 
 Start new topic
Replies (1 - 3)
Jack Cowley
post Nov 25 2004, 11:37 AM
Post #2

Retired Moderator
Posts: 37,716
From: The San Francisco Bay Area
Me.SubformControlName.SetFocus
DoCmd.GoToRecord, , acNewRec

hth,
Jack
Go to the top of the page
 
+
obaccessed
post Nov 25 2004, 05:13 PM
Post #3

UtterAccess Member
Posts: 21
That worked great - Thanks!
Go to the top of the page
 
+
Jack Cowley
post Nov 25 2004, 06:07 PM
Post #4

Retired Moderator
Posts: 37,716
From: The San Francisco Bay Area
You're very welcome...

Jack
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 03:00 PM