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 November 19th, 2003, 04:12 PM
OCM OCM is offline
Registered User
 
Join Date: Nov 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Blank form

I have a main form frmHousehold and a subform frmApplicants.
In my tblApplicants I set AppDate field required to yes. I also want the form to open blank, which it does.
I don't have a default value in the subform, but when I close it without entering any record:

1. Access assigned an ID and saves it as a record
2. I get a message saying, "AppDate is a required field…"


I would appreciate, if you e-mail me with an idea!

Thanks,

OCM

 
Old November 19th, 2003, 04:36 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

In design view for your table, check to see if there is a "Yes" under required on the general tab.

Do you have your form set-up as "Data entry" under properties?



Sal
 
Old November 20th, 2003, 08:48 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

One possible explanation: Your table may not assign default values, but in your form's "On Open", "On Current", or "On Activate" event you have code that is assigning a value to a field as soon as the form opens and activates. When that happens Access will create a record for it, even if the field it initialized may be invisible on the form. Make sure this code is eliminated. The best way to assign (uncalculated) default values without actually creating a record at start-up is to put a default value in the table.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division





Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Form to Add New Record is Blank echovue Access 9 July 10th, 2013 03:38 PM
How to add new blank record to data form? Kia Visual Basic 2005 Basics 1 June 12th, 2007 02:11 AM
leaving blank text box in form when inserting data saif44 ASP.NET 2.0 Professional 1 March 9th, 2006 07:29 AM
Blank Form KennethMungwira VS.NET 2002/2003 2 December 23rd, 2003 03:12 PM
Blank Jeeper BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 1 August 21st, 2003 03:05 PM





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