Finding a record on a subform 2

[Iris601]

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.

 

[FancyPrairie]

For starters, verify that the "Match" criteria of the Find dialog box is what you expect it to be.

 

[Iris601]

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.

 

[kalDurak]

I'm having the same problem...I noticed that there has been no response to this post in over a year, but hopefully someone has the answer. The search works occassionally, but 80% of the time, it doesn't. While I'm not very familiar with Access, I am computer literate, so I can follow a technical explanation if necessary.

 

[formerTexan]

Can one of the folks having a problem display their applicable code for review and indicate where it is being called from. Also, is the field being searched a text or memo field?

Cheers,
Bill

 

[willir]

Or supply the table design showing header and detail tables, and indicate which field you are trying to match.

 

[Iris601]

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 that the text was not found. So what I did was create a filter by form page where my users could search all fields on the form, no matter if they were on the main form or the subform. So that has solved my problem, and my users are very happy. Plus some other Programmers have asked me to make it available to their applications as well.

 

[FancyPrairie]

I'm wondering if you were misinterpretting what the Find command was doing. When you are in a subform and issue the find command, your are actually searching filtered records. That is, only those records that the match main form. For example, suppose my main form displayed the name of a department and the subform displayed the names of all employees in that department. If I tryed to find an employee (via the subform) that did not exist within the dept shown, it would not find it (even though the employee exists).

 

[Iris601]

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 on the subform, matching on the middle name as "Carl", it pull them all up. It works lovely.

 

[kalDurak]

FancyPrairie, I think you hit the nail on the head! I tried running the subform and my code behaves as expected...Now all I have to do is figure a way around the problem. Unfortunately, I don't have the option of creating a filter form...The user community would freak!

 

[Iris601]

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