K
Karen
I have an app (Access 2003) that is opened by up to 8 people at a time
with a frontend installed and sharing the backend on the network.
Most users have Access Runtime. One user (using runtime) has been
seeing cases where he is asked to refer to a specific record (we use a
field called reference to refer to a record) but when he enters the
reference number in the search control (an unbound control), the
record can't be found. Another computer can find that record, and
when the first user exits the app and restarts it, he can find the
record.
is this making any sense?
the code behind the search control is
With Me.RecordsetClone
.FindFirst "Reference=" & Me.Text863
If Not .NoMatch Then
Me.Bookmark = .Bookmark
Else
MsgBox "No Incident Found"
End If
End With
REFERENCE.SetFocus
Me.Text863 = Null
Thanks for any help,
Karen
with a frontend installed and sharing the backend on the network.
Most users have Access Runtime. One user (using runtime) has been
seeing cases where he is asked to refer to a specific record (we use a
field called reference to refer to a record) but when he enters the
reference number in the search control (an unbound control), the
record can't be found. Another computer can find that record, and
when the first user exits the app and restarts it, he can find the
record.
is this making any sense?
the code behind the search control is
With Me.RecordsetClone
.FindFirst "Reference=" & Me.Text863
If Not .NoMatch Then
Me.Bookmark = .Bookmark
Else
MsgBox "No Incident Found"
End If
End With
REFERENCE.SetFocus
Me.Text863 = Null
Thanks for any help,
Karen