On my database y have 8 coluns and in the column "TYPE" y want to find
whitch regists have "lux" in that column.

I want also print that regists in a menu with LABELS.

Thanks!

 > I am making a program using VB6 and access2000.
 > How can i find an expression (ex:lux)on a colun of database?
 > whitch comand/control do i use?
 >
 > On my database y have 8 coluns and in the column "TYPE" y want to find
 > whitch regists have "lux" in that column.

Use an SQL statement to open your Recordset instead of opening a Recordset
on the Table itself, something like

       SELECT * FROM YourTableName WHERE [Type] =""" & "lux" & """"

That will return only the Records that contain the text "lux" in the Field
Type.

 > I want also print that regists in a menu with LABELS.