J
JBad
Hi..
i want to find a number (employee code) and if that exists in the table
(employee master), then retrieve the rest of the details of that record and
display those deails in either textboxes or labels (which would b not
editable).
wht is the easiest way to do it? i've tried the findrec & bookmark methods
but i cant make it work..
following is the code i use for bookmark method:
Dim rs As Recordset
Set rs = Me.RecordsetClone
rs.FindFirst “EmpNo = “ & txtBox_1.Value 'txtBox_1.value is wht the
user enters
If Not rs.NoMatch = True Then
Me.Bookmark = rs.Bookmark
End If
i want to find a number (employee code) and if that exists in the table
(employee master), then retrieve the rest of the details of that record and
display those deails in either textboxes or labels (which would b not
editable).
wht is the easiest way to do it? i've tried the findrec & bookmark methods
but i cant make it work..
following is the code i use for bookmark method:
Dim rs As Recordset
Set rs = Me.RecordsetClone
rs.FindFirst “EmpNo = “ & txtBox_1.Value 'txtBox_1.value is wht the
user enters
If Not rs.NoMatch = True Then
Me.Bookmark = rs.Bookmark
End If