Subform fails after pressing remove filter button

J

jpuls

I have a form in an Access 2003 Data Project (.adp file). The form
itself works ok, but when it is run as a subform, I get an error with
the following sequence of events:

1. Select a field, use the Find button to find a record with a
particular value for the field.
2. Use the Filter by Selection button to select a subset of the
records.
3. Use the Remove Filter button.

At that point I get a sequence of two errors:

The record source 'SELECT TOP 100 PERCENT ..." specified on the form
or report does not exist. You misspelled the name, or it was deleted
or renamed in the current database, or it exists in a different
database.

After clicking OK, I get this error:

Run-time error '2465':
Microsoft Office Access can't find the field 'Firm' referred to in
your expression.

Pressing Debug highlights the line:

If Not VBA.IsNull(Me.Firm) Then ...

The parent form in this case really does no more that run one of a
number of other forms in the application. It's like a master menu.

Does anyone have any sugestions as to what is wrong?

Thanks!
Jim Puls
Sentinel Technologies
 
Top