afterupdate code problem

nobbie1

Registered User.
Local time
Today, 16:04
Joined
Aug 13, 2003
Messages
25
Hello all,

I have this code in my afterupdate event for a combo box:

Dim rs As Object

' Find the record that matches the control.
Set rs = Me.RecordsetClone
rs.FindFirst "[TechID] = " & (Me![TechnicianList])
Me.Bookmark = rs.Bookmark
Set rs = Nothing

This lets my techs select their name from the combo box and it then populates 2 text fields with their first and last name (display only, no storage) In the subform where they input all their days work it used to bring it up to the current date, but now after selecting a tech's name it's showing entries from previous dates.

Is there a way I can stop this from happening? I'll post my database since I think that might help more than my explanation has.
 

Attachments

Users who are viewing this thread

Back
Top Bottom