Hi,

I wan't to make a searchbox, where users can search for a unique number in a database (access 2007, saved as older version .mdb). The numbers are held in column 4 (named 'Product Code'). A Cmdbutton (Check) activates the search, and puts the text/data, that is found in the same Record (column 2 & 3) in label1 & label2.

My code about this:

Code:
(General)-(Declerations)
Private RS As ADODB.Recordset

(Form)-(Load)
Set RS = New ADODB.Recordset
With RS
   .Open "Product_List", CN, ....
End with


Private Sub cmdCheck_Click()
   ...
   RS.Find ("Product Code = .............")  'Should be like txtSearch.text, i thought:(
   lbl1.Caption = "RS.Fields.Item("Product Name")
   lbl2.Caption = "RS.Fields.Item("Price")
   ...
Questions:
1. Do i need to 'RS.Open or Close anywhere? or is that just for writing to a database?
2. How do i declare the Searchbox's text as the 'To-Be-Searched' information?

I've tried the FAQ's but could find it.

Thanks in advance!