[rk2008]

Hi,
I'm using following code to select a record on a form from dropdown list and I'm using MSSQL ODBC linked tables inside MS Access:

Expand|Select|Wrap|Line Numbers

1. Private Sub cboFind_AfterUpdate()
2.   Dim strCriteria As String
3.   Dim rst As DAO.Recordset
4.  
5.   Set rst = Me.RecordsetClone
6.    strCriteria  = "[EmployeeID] = " & Me![cboFind]
7.  
8.   rst.FindFirst strCriteria
9.   Me.Bookmark = rst.Bookmark
10.  
11. End Sub

But I have a problem, if one person opens form A and select one of the records from the dropdown list it works fine. Now at the same time if second person open the same form A from the same copy of MSAccess the first form A starts pointing to the new record selected by second person and save changes to the newly selected record. How can I prevent this from happening, so that each instance of form A points to its selected record?

Thanks

[PianoMan64]

You have to create a new form with a new recordset. otherwise whatever you do in the second form will refect in the first one until you break the chain between the two.

If you want to open multipule copys of the form A, then you're going to need to create them in VBA for each one you want to have open. This isn't something MS Access supports because it assumes that it has only one recordset per form.

If you need code examples, please let me know.

Thanks,

Joe P.