find/replace

[chriske911]

when a user searched for a value with find/replace from a form he got the
message the value could not be found
but when I looked for it in the table it was there
can it be that a value is searched only inside the subform's data and not in
the entire dataset ?

thnx

 

[John Vinson]

can it be that a value is searched only inside the subform's data and not in
the entire dataset ?

Yes, that is exactly correct. That's how subforms work.

 

[John Vinson]

I was already affraid of this thus the obvious question would be how to
circumvent this ?

Well, what does it MEAN to search in a Subform? A subform shows the
records associated with the currently selected record on the mainform.
Would you want to find a record in the Subform's recordsource and have
the mainform switch to a record associated with the found record? What
if it's a many to many situation and there are dozens of mainform
records all associated with the found record - which do you want to
see? Would you want the found record to create a new record associated
with the currently selected mainform record, or to lose its current
association and become assoicated with the current mainform record
instead?

Just in terms of logic, it's not at all obvious what "searching a
subform" SHOULD do, and it may well vary from application to
application!