Solved

Form won't save record

Posted on 2015-02-12
3
170 Views
Last Modified: 2015-02-12
I have form that has just an auto-populate date field on it.  The default is set as =Date()

Then on that form I have a sub-form, actually as a datasheet where records are entered.  

My problem is that the main form record isn't being saved to the main forms table unless I manually enter the date.

Why?
0
Comment
Question by:SteveL13
  • 2
3 Comments
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 40605840
That's by design. You have to enter/change something in a form to make it "Dirty", then you can save it.
Until then, it is just a new record with default values or not.

/gustav
0
 

Author Comment

by:SteveL13
ID: 40605902
Ok.  I just added a field that I ended up needing anyway.  Thanks.
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 40605911
You are welcome!

/gustav
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question