Can't search fields on subform

  • Thread starter Thread starter Isidore
  • Start date Start date
I

Isidore

My DB consists of two tables:
1) Clients (address info, etc.), includes ClientID
2) Services (includes date of service, who provided the service, type of
service), related to Clients by ClientID.

I built a tabbed form based on the Client Table which includes a subform (on
the second tab) based on the Services table.

Problem: I can't search or filter on any of the fields in the subform. When
I try to search, for example, I get the error message:

You can't used Find or Replace now.
The fields are not searchable due to one of the following:
* The fields are controls (such as buttons or OLE objects)
* The fields have no data
* There are no fields to search

I know neither of the last two are true. Does the fact that the fields in
question are on a subform render them controls? Is it the tabs? Is there a
way I can make these fields searchable from the existing form?

Thanks in advance for your help.

Isidore
 
If I remember correctly, the default search function only works on main
forms and data sets. The subform, once loaded, ceases to actually be
considered a form for most purposes in access. The best way to combat this
is to develop your own search form, and use the filter property of the main
form to display the results of the search.

Hope this helps,
- Glen
 
Back
Top