Changing a default value on the fly

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 391,814 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,525 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser:

Thread Tools Display Modes

Views: 1728 | Replies: 1

•

Join Date: Feb 2007

Posts: 1

Reputation: Athlete is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Athlete

Offline

Newbie Poster

Changing a default value on the fly

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?

•

Join Date: Mar 2005

Posts: 65

Reputation: cpopham is an unknown quantity at this point

Rep Power: 4

Solved Threads: 0

cpopham

Offline

Junior Poster in Training

Re: Changing a default value on the fly

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