Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding date to Form

Status
Not open for further replies.

nath01

Technical User
Apr 13, 2004
74
GB
i am useing front page 2000.

and i have a form with a drop down box, how can i get it so when Yes is selected in the drop down box it populates the date/time to another field

so when yes is selected in field1 it will populate yes to fild1 and also populate the date/time to fild2

or is there any other way to do this that you know of?

Thanks in advance for any help
 
Use an if statement in the After_Update event. Something like:
Code:
If [DropdownName].value = "Yes" (most likely "0") Then
    [Fld2].value = "=Now()"
Else
    [Fld2].value = " "
End If

This syntax is probably nowhere close to exactly how it needs to be written, but I was running close to quitting time and thought I would offer you some thoughts on the basic concept. It should get you started.

coachdan32

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top