DoCmd.FindRecord

[nbohana]

I am using the following code to find a record in my data table. I find the record ok, but it only displays the last name (lname) and does not display the complete record. I need some help can someone tell me how to get the complete record.

Thinks for you help

Private Sub Find_Click()
On Error GoTo Err_Find_Click

Dim IdValue As String

IdValue = Me![Search-Box]

DoCmd.FindRecord IdValue, acEntire, True, A_ALL, True

Exit_Find_Click:
Exit Sub

Err_Find_Click:
MsgBox Err.Description
Resume Exit_Find_Click

End Sub

 

[johnwm]

Hi and welcome to Tek-Tips. Please read faq222-2244 to get the best from these forums.

It looks as if you may be asking an Access VBA question rather than a VB3/4 question since you are using Access constants. If that is the case you will do better asking this in forum705.

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints