Member Avatar for Athlete

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?

  • 2 Contributors
  • 1 Reply
  • 107 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by cpopham
Member Avatar for cpopham

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.