how to search ?

hello, i am new to access.
I have a form here, all the textboxes are bounded to a table to store the information. What should i do if i want to search for the rest of the details of a record by key in a key like ID? It is like i key in the ID in the ID textbox then the rest of the information will be displayed when i press the search button. The display would be exactly same like the form where the user key in the information during ADDing process.

anyone can help me ?

Why not just use the same form where you add records and use that same form to display records? I see no need in a second form. If you use the same form then you can use the bookmark properties to quickly locate the record you want.

Dim intSearch As Integer
intSearch = [txtID].Value
Me.RecordsetClone.FindFirst "[ID] = " & intSearch
Me.Bookmark = Me.RecordsetClone.Bookmark

The above assumes your ID is a number not a text.

lwells

i will b using the add form to display the search results.
Can you please explain more about the bookmark property? I do not understand how the property works.

Thanks

i tried out the codes above, it prompted out a message like this :

Run Time error ' 7951':
You entered an expression that has an invalid reference to the RecordsetClone Property.

What does this mean?