(SOLVED) Index Based on Unknown field error (TDBf)

[bill0287]

I am using an existing dbf file from an old Delphi app. I am trying to filter the TDbf data using something like this:

Code: [Select]

  If DBLookupComboBox1.Text <> '' then           // this is looking in a field called REGNAME
   with ReportDBf do begin
      Filter := DBLookupcomboBox1.Text;                       //I want to filter the table on all rows matching the REGNAME selected above
      Filtered := True;
      end;

When I run this I get the following error:

Index based on unknown field "<the value of whats in the lookup combobox>"

I have tried looking at the tdbf tutorial and some other example but still don't understand how to set up the Filter option correctly to do this.

Any suggestions?

UPDATE:

This code seems to be working:

Code: [Select]

  If DBLookupComboBox1.Text <> '' then
    with ReportDBf do begin
      Filter := 'REGNAME=' + QuotedStr(DBLookupcomboBox1.Text);
      Filtered := True;
      end;


[LacaK]

What is in DBLookupcomboBox1.Text ?

[bill0287]

It's the data from the field REGNAME from ReportDBF.

So for example, the DBlookupcombox1 has the value = Bob

The error message reads: Index based on unknown field "Bob".

I know I must not be setting the filter property correctly, but the examples aren't helping me.