Changing a default value on the fly

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Reply

Join Date: Feb 2007
Posts: 1
Reputation: Athlete is an unknown quantity at this point 
Solved Threads: 0
Athlete Athlete is offline Offline
Newbie Poster

Changing a default value on the fly

 
0
  #1
Feb 23rd, 2007
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?
Reply With Quote Quick reply to this message  
Join Date: Mar 2005
Posts: 65
Reputation: cpopham is an unknown quantity at this point 
Solved Threads: 0
cpopham cpopham is offline Offline
Junior Poster in Training

Re: Changing a default value on the fly

 
0
  #2
Mar 6th, 2007
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
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:




Views: 2808 | Replies: 1
Thread Tools Search this Thread



Tag cloud for MS Access and FileMaker Pro
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC