update feild based on combo box value

[Toby Gallier]

Hi, i have a newbie question.

How would i update a feild based on the slection of a combo box ? I
have a "status" combo box that represents the status of work. there
are 3 diffrent steps, and i want to record the dates of when the
"status" combo box is udpated with a partiuclar value, or step. For
exmaple a new record is created and the the "status" combobox reading
"step 1" when the form is submited i want it to update the record with
the status feild as "step 1", as well as a the "step 1 date" feild with
the date of when step 1 was slected in the combo box. Someone the
would come back and change "step 1" to "step 2" i would then want to
udpate the "status" feild with "step 2" and the "step 2 date" feild
with the date step 2 was selected in the combo box. and so on.

basicly i want to track the progression of work based on when the
records "status" combo box was updated with particular values.

Thanks!!!

 

[Pieter Wijnen]

something like (event procedure for Combo1 AfterUpdate)

Private Sub Combo1_AfterUpdate
CurrentDb.Execute "UPDATE MyTable SET STEP='" & Me.Combo1.Value & "',
DateRecorded=Date() WHERE TheKey=" & Me.KeyField.value
End Sub

ought to do it

--
Pieter Wijnen

My feeble Access pages (good links though)
http://www.thuleeng.com/access
When all else fail try:
http://www.mvps.org/access
http://www.granite.ab.ca/
http://allenbrowne.com/
http://www.lebans.com/