Problem in fetching records to a combobox(ODBC)

Hi All,I have two combobox fields(Brand,Product) in a Form. I am fetching records from a SQL Database table(ProductInfo). I have already fetched records into the combobox1(Brand). Now what I want is to fetch the relevent records in combobox2(Product) when a user selects combobox1(Brand).

Your early response is verymuch appreciated.

Thanx in advance,

Buwaneka

Subject: Problem in fetching records to a combobox(ODBC)

set the field property of combobox2(Product)to “Refresh fields on keyword change”

Subject: RE: Problem in fetching records to a combobox(ODBC)

I tried that, but it does not work…