Auto Pop a box with a date

[winterh]

I have a form which has a number of fields one is a drop down with only one option "Done", what I want to happen is when a user selects "Done" it put todays date into a date box next to it.



I guess this is a simply thing but I cant get my head around it.

Thanks for the help.

Hads

[pbaldy]

If Me.ComboName = "Done" Then
  Me.TextboxName = Date()
End If

[Missinglinq]

A Combobox with a single item is a bit of overkill, wouldn't you say?

Also, what happens if the user makes a mistake? With a Combobox, you cannot simply go back in and select 'nothing!' The user would have to go in and physically delete the 'done' or you'd have to code something to set it back to Null, and do the same thing for the Textbox.

Far better, for this kind of thing, to use a Checkbox named ckbDone and have its Label say Done. Then you could use

Private Sub ckbDone_AfterUpdate()

If Me.ckbDone = -1 Then
  Me.TextboxName = Date()
Else
  Me.TextboxName = Null
End If

End Sub

Linq ;0)>

[winterh]

Hi Guys

I have to us a drop down as I have a number of options for the user to pick eg "Done", "Open" or Blank.

This is the code I have used which seems to to put the date in "ToDoDoneDate1"

If Me.ToDoStatus1 = "Done" Then
Me.ToDoDoneDate1 = Date

Any Ideas?

[winterh]

Hi Guys

I have to us a drop down as I have a number of options for the user to pick eg "Done", "Open" or Blank.

This is the code I have used which seems not to put the date in "ToDoDoneDate1"

If Me.ToDoStatus1 = "Done" Then
Me.ToDoDoneDate1 = Date

Any Ideas?

[pbaldy]

Is there only 1 field in the combo, or perhaps is there a key field?

[Missinglinq]

Hi Guys

...I have to us a drop down as I have a number of options for the user to pick eg "Done", "Open" or Blank...

If that's the case, why did you originally say:

...one is a drop down with only one option "Done"...

We can't give valid advice if we're fed incorrect information!

Linq ;0)>