Buitl in "FIND" can not work on the subform

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

In my church membership database I have a form base on query of member
table and addres table. Then on the other tab, I have a subform for Notes for
each member linked with member_id.

So in the subform I have a kind of note with fields date, time, subject, memo
When I tried to use the built in Find of the access ( the on in the
uppertoolbar), to find the word in the memo or subject field It can not work.

My question is how can we make that the built in " Find" can work for all
the fields in the database no matter if it is a form or subform.

Thanks for any idea.

Frank
 
Hello, is this a difficult question, I do not seem anyone have answered this

Thanks

Frank
 
Hi Frank,

I encountered this issue awhile ago. The problem is that when you
search for something in a subform, it only searches the currently displayed
records. That is, the records related to the record in the main form.

My solution, which may not be what you need was to create a separate
find form all my own. The user types something into a single field such as
an invoice number, some text to find, a part number or any of a number of
other things. When the user clicks find button it uses a really complicated
union query to search all of the appropriate fields in the main table and in
a number of child tables. It then constructs a list of the primary key
values for the main form's table so the user can browse forward and backwards
through the list, using Next and Previous buttons on the form. It took a
decent bit of programming but the users are happy now.

As a possible, untested alternative, you might create a query that
joins the main form's table and the subform's table, and display the results
in a subform on a separate tab just for searching. Then the user could do
the anywhere search on that tab. You could then use the search subform's On
Current event to reposition the main form to the appropriate record.

Hope that helps point you in a useful direction,

Clifford Bass
 
Back
Top