"Box666" wrote in message
...
ch ref no is unique - so no duplicates. The 2nd column is text only ax 20
char.
No problem. The RefNo field would be the primary key. You could easily
make a form, bound to the table, in which you key the refno you're looking
for into an unbound text box, and then code in the text box's AfterUpdate
event that locates the record that corresponds to the refno the user entered
in the text box. Code would look something like this:
'------ start of example code ------
Private Sub txtFindRefNo_AfterUpdate()
If IsNull(Me.txtFindRefno) Then
With Me.RecordsetClone
.FindFirst "RefNo = " & Me.txtFindRefNo
If .NoMatch Then
MsgBox "RefNo " & Me.txtRefNo & " was not found."
Else
Me.Bookmark = .Bookmark
End If
End With
End If
End Sub
'------ end of example code ------
--
Dirk Goldgar, MS Access MVP
Access tips:
www.datagnostics.com/tips.html
(please reply to the newsgroup)