Form search

  • Thread starter Thread starter elima
  • Start date Start date
E

elima

My problem is that I have creates a few forms. I have them set to search for
information and then display on the subform that is on the main form. Well it
seems to work fine in some of the forms, but then not in some others. I have
checked the property sheet on the working ones and the nonworking ones and I
seem to have everything the same. Also the code for each is the same. What
could be wrong? Any solutions or thoughts?
 
There could be lots of things wrong, and we can't see or debug what you are
doing, but one place to look might be in the LinkMasterFields and
LinkChildFields. Perhaps the failing forms have something in these
properties of the subform control (on the main form) that prevent them
displaying the results you expect.

It's quite common to use a subform to display results, but you may be able
to get by with just putting the search boxes into the Form Header section of
a Continuous form, and showing the results in the Detail section. If it's
any help, there's a downloadable example of that kind of form here:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
 
Thanks Allen, I actually had the exact coding you had for your form. I still
could not see what was happening so I changed the form, I took your advice
about just having the search items in the header and the result boxes in the
detail. When I changed the form this way it worked! Thanks again
 
Back
Top