943,787 Members | Top Members by Rank

Ad:
Feb 23rd, 2007
0

Changing a default value on the fly

Expand Post »
I need to create an environment that allows a data-entry person to change the default date for records on the fly.

i.e. she's entering row upon row of historical data, and the date changes. I don't want her to have to manually enter the date for each record but I don't want her to have to go the design view of the destination table everytime the date on the paper-records changes.

Any thoughts?
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Athlete is offline Offline
1 posts
since Feb 2007
Mar 6th, 2007
0

Re: Changing a default value on the fly

You could use a variable. Put a form level variable that is set to the current date on form load and assigns the variable date to the field. Then on the field on the BeforeUpdate assign the date that is entered from the field to the form level date. In the OnCurrent event set the field to the form level variable.

There may be easier ways, but I just through that together.

Chester
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
cpopham is offline Offline
65 posts
since Mar 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS Access and FileMaker Pro Forum Timeline: .Net Application Development Using Database
Next Thread in MS Access and FileMaker Pro Forum Timeline: [Stupidity] I Forgot My Ms. Access Database Password. Help..





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC