drop down box

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

Guest

When I used the drop down box on my form, I would like it to populate a time
and date box.
 
Use the AfterUpdate event of the combo box control to write the current time
and date into textboxes on the form:

Private Sub ComboBoxName_AfterUpdate()
Me.TimeTextBoxName.Value = Time()
Me.DateTextBoxName.Value = Date()
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating forms w/combo boxes 1
Drop down boxes 1
Outlook from .dotx to .oft 1
Combo Box Question 1
Create a Subform to Search Main forms records 3
Problems with drop down boxes. 5
Calculating time 2
combo box locked 4

Back
Top