G
Guest
hello all,
I'm using MSAccess 2003 for a database that I create with multiple users.
One main table and form is used.
tblLog
frmPrepUser
Here is my problem.
When the database is running on all machines...
User A enters new record.
User B searches for that record using the combo box search for a record on
current form. - You can see the new entry but if you select it, it doesn't
show up on the main form. In fact, you can't even find it using the
navigation buttons. The only way you can get to the record is to close out of
Access and reopen.
I've tried adding: requery, refresh and recalc to the code to no avail..
Private Sub Combo266_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Me.Refresh
Set rs = Me.Recordset.Clone
rs.FindFirst "[CLIENT] = '" & Me![Combo266] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
Any ideas???
Please help!
I'm using MSAccess 2003 for a database that I create with multiple users.
One main table and form is used.
tblLog
frmPrepUser
Here is my problem.
When the database is running on all machines...
User A enters new record.
User B searches for that record using the combo box search for a record on
current form. - You can see the new entry but if you select it, it doesn't
show up on the main form. In fact, you can't even find it using the
navigation buttons. The only way you can get to the record is to close out of
Access and reopen.
I've tried adding: requery, refresh and recalc to the code to no avail..
Private Sub Combo266_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Me.Refresh
Set rs = Me.Recordset.Clone
rs.FindFirst "[CLIENT] = '" & Me![Combo266] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
Any ideas???
Please help!