Default value

[stuartandwil]

Is there any way to make the default value for a new record default to the last records value. I have drop down boxes to pick from teams 1 - 5 and drop down box for Nights and days then various others. For every new record made that shift I dont want to have to keep selecting the choices for team and shift. Then when new shift come on they pick their values on their first entry to the database but then it defaults to these new values.

Probably not possible!

 

[bat17]

There are probably several way to do it but here's one to get you started. Add a checkBox in the form header for Nights/Days then in the afterupdate event of the first field they fill in add something like

If Me![CheckDays] = True Then
Me![SHIFT] = "DAYS"
Else
Me![SHIFT] = "NIGHTS"
End If

HTH

Peter

 

[stuartandwil]

Can see how this could work but how to I get to see the header in form view. I have put the checkbox in the header of the form but when I go out of design view I don't see the header.

Many thanks

 

[stuartandwil]

Sorry there, read the help files and got it working as required, however unsure how to tackle the team part, 5 teams 1-5. Any thoughts?