Find and Replace not working

[lacey]

Hello,

I have a form ("Contacts Form") that I use with a few subforms on it. One of the subforms is "sbfrmCompanys" that has information on the contacts company. One of the fields in sbfrmCompanys is "Organization." Users used to be able to use the "find" feature to search for an organization's record, however the "find" feature suddenly stopped working. Now, when a user searches for an organization that I KNOW is in the company table, a dialogue box appears that says Access has finished searching and no records were retrieved. This cannot be so because I know for a fact the particular value I am searching for is in the table.

Any ideas of what is going wrong? Let me know if I need to provide more information.

Thanks.

 

[jdraw]

Please show the related code, or a zip of the database after having removed anything confidential.

 

[lacey]

Here we go.

View attachment Contacts 1.0.zip

 

[vbaInet]

It's best you upload your db with some test data. Just one record isn't sufficient for this test. And also give some steps on how to reproduce the problem (i.e. what to enter and what you expect).

 

[GinaWhipp]

Lacey

When searching via the Subfrom note that those records are filtered to the Main Form, so technically, the Find is only searching the subset of records. I think that is what you are experiencing because the Find and Replace works.

I'm also going to make a suggestion that you change your field name *Date* in table Notes to something else as it is a Reserved Word and will cause you a problem. For a complete list of Reserved Words see...
http://allenbrowne.com/AppIssueBadWord.html

 

[lacey]

My apologies, I should have been more clear. I am receiving the error message only when using "Find and Replace" on the field "Organization," which is on sbfrmCompany. The Find function does appear to work in all other areas of the form except this one.

Also, thanks for the tip about the "Date." I will change that.

Let me know if there's any ideas. Thanks!

 

[vbaInet]

Did you understand what GinaWhipp is saying about it findind a subset of records?

 

[GinaWhipp]

Lacey,

Let me put this another way... Find And Replace will not work in the Subform. It will not cycle thru all the records in a Subform. There is no way to change that.