Dear All,

I have the following question.

I need the VB code for opening and closing a .dbf file and find a string in a colom.
-------------------------------
example:

car.dbf contains a record

[brand] [engine][doors] [speed] [number]
[dodge] [4liter] [3 doors][256 max][54321]
[chrysler][2.5liter][5 doors][240 max][12345]

variable getnumber = 12345
variable brandback = ""

open car.dbf
search for getnumber in colom [number] in dbf
get "chrysler" back and put in variable brandback
close car.dbf

Thanks

Grz. Shinoby