default value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that asks the user for a date range. The first text box asks
for the beginning date & 2nd box asks for the user to enter the ending range.
USUALLY the 2nd box will have the same value as the 1st box. Is there a way
to have the 2nd box default to the value entered in the first box, yet
leaving the option for the user to change the 2nd box in the few instances
where the date may be different?
 
Set the value into the second TextBox in the AfterUpdate event of the first
Text Box -- then you can click on that Text Box and modify it, if need be.
The code would be something like:

Me!cboSecond = Me!cboFirst

Larry Linson
Microsoft Access MVP
 
I have a form that asks the user for a date range. The first text box asks
for the beginning date & 2nd box asks for the user to enter the ending range.
USUALLY the 2nd box will have the same value as the 1st box. Is there a way
to have the 2nd box default to the value entered in the first box, yet
leaving the option for the user to change the 2nd box in the few instances
where the date may be different?
Click to expand...

Code the AfterUpdate event of the StartDate control:

EndDate = StartDate.

The user can simply write over the date to change it
 
Back
Top