I have a form that displays selected fields from a single table. The primary key field (Account) is shown in a combo box. The BoundColumn = 1 (the key = the 1st field). I want the user to be able to type in a key value and then have the form display the other fields from that record. But doing this results in an error message saying the changes would create duplicate values in the key. The name of the combo box is "Acct" and has the following code in the AfterUpdate event:
Me.RecordsetClone.FindFirst "[Account] = " & Me!Acct
Me.Bookmark = Me.RecordsetClone.Bookmark
Me.Repaint
But even after commenting out this code, I get the same error.
The record navigation buttons work, but there are over 100,000 records in the table, so being able to type the value is necessary.
There's got to be a straight-forward way of doing this basic task, but what is it?
Me.RecordsetClone.FindFirst "[Account] = " & Me!Acct
Me.Bookmark = Me.RecordsetClone.Bookmark
Me.Repaint
But even after commenting out this code, I get the same error.
The record navigation buttons work, but there are over 100,000 records in the table, so being able to type the value is necessary.
There's got to be a straight-forward way of doing this basic task, but what is it?
Last edited:
