Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 22nd, 2007, 01:02 PM
Registered User
Join Date: Mar 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Stop Tab out of subform

Is there any way to stop the subform from going to a new record when you leave it? I've gone so far as to add an extra control to the form that doesn't get filled in and code the primary form to get focus...still resets the subform on exit :(

just found the glitch and need to fix it ASAP...

Old April 22nd, 2007, 03:44 PM
Authorized User
Join Date: Apr 2007
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts

Wonder what would happen if you set the properties of the "data entry" on the subform to no rather than yet. I'm still new with Access but it worked for me to not allow people to edit certain controls on the forms like an autonumber, date created, like things that i don't want changed.

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to disable a tab on a tab control. dbradley VB.NET 6 April 14th, 2011 10:04 AM
Stop button won't stop loop JDShaffer Visual Basic 2008 Essentials 3 May 23rd, 2008 03:22 PM
tab stop angelboy C# 2005 1 June 19th, 2007 04:33 AM
Form and SubForm stop work lijandra Access VBA 0 August 16th, 2006 12:48 PM
Filter Subform B Based on Field in Subform A SerranoG Access VBA 3 June 18th, 2004 12:23 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.