F
floyd33 via AccessMonster.com
I have a combo box field set up to look up the project code field assigned to
a meetingID field, showing only the project code. I have an event procedure
set on the field "after update" to find the record that matches the code.
Below is the code I've used. The problem is that about half the time I click
a code to look up, it defaults back to the first record in the table, which
is obviously not the record I've chosen. No matter what I do, I can't get to
the record. Please help me figure out why!
Private Sub Combo6418_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[MeetingID] = " & Str(Me![Combo6418])
Me.Bookmark = rs.Bookmark
End Sub
a meetingID field, showing only the project code. I have an event procedure
set on the field "after update" to find the record that matches the code.
Below is the code I've used. The problem is that about half the time I click
a code to look up, it defaults back to the first record in the table, which
is obviously not the record I've chosen. No matter what I do, I can't get to
the record. Please help me figure out why!
Private Sub Combo6418_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[MeetingID] = " & Str(Me![Combo6418])
Me.Bookmark = rs.Bookmark
End Sub