Search results for query: *

There's nothing like shaking up the users a little, as long as they are happy in the end. Here's where I started at: http://courses.mgmt.dal.ca/comm3516/access_2000_sampledb.htm Hyperlink: Access 2000 Sample: Query-By-Form Database

Yes, that makes logical sense - very good point. So since I went in the other direction by creating the separate filter by form to search ALL of the records, it then pulled up the records matching what was shown on the subform. For instance, I want to find all the occupants of a house that's...

When I worked on this last year, there was no "special code" out of the ordinary that I was trying to use. All I had was a find button on my form. And when I'd click into the field one the subform attached to my main form, it would not find the data in that field. It would just give a message...

The criteria in the Find Dialog box is correct. I have already verified that. The recordsource for the attached subform is a table. The recordsource for the mainform is a query. The subform is correctly linked to the mainform.

Here's and example how I reference a control on my subform from the Main Form to make a control visible: Me.subform!ControlName.Visible = True

I have two subforms that contain Owner and Occupant information (i.e. Name, address, etc.). Whenever the user tries find data in a field using Find, it says the search item was not found, even if it does exist in a record. Anything outside of the subform works.