I want to see 3 different sections on a form called Project History, each
section performs it own searches and I want them to work independently of
each other - I already have these sections created but my problem is listed
below:

I) a search by project number that allows user to enter project number and
click a button to bring up the info from the report; the search happens in
the detail section of the form.

II) a search for pending files that allows user to view and print a report
of all pending projects, he can also input a project number and search for it
alone after clicking on a command. search happens in detail section of form.

III) user enters a start and end date to search on projects' award dates. a
command button displays the search results in a report. the criteria are
entered in the header and the detail section displays the results.

I changed the record source to include all 3 queries and picked up the
fields that I want on my form. However, searches I and II above, pull in no
data. I am only able to search in III that has info in the header and detail
sections. any suggestions?

--
Thanks, Karen

Hello Karen:

You need to separate your data sources! You need one main form and
3 subforms. The easiest way to do this is to copy your existing form
into 3 forms. Then individually delete all but one of the 'forms'
within each of those forms and shrink them down to size. Then create
the main form with the 3 subforms in it. When it asks you to link
fields, just ignore it.

Personally, I would make 3 different forms and then set them all to
"Popup" but not "Modal". Then I would have a "starter form" that runs
at startup, opens the 3 forms for you, positions them on the screen,
and closes itself. That way the user can rearrange the 3 forms he/she
has open.

Good luck!
~J


Karen wrote:
> I want to see 3 different sections on a form called Project History, each
> section performs it own searches and I want them to work independently of
> each other - I already have these sections created but my problem is listed
> below:
>
> I) a search by project number that allows user to enter project number and
> click a button to bring up the info from the report; the search happens in
> the detail section of the form.
>
> II) a search for pending files that allows user to view and print a report
> of all pending projects, he can also input a project number and search for it
> alone after clicking on a command. search happens in detail section of form.
>
> III) user enters a start and end date to search on projects' award dates. a
> command button displays the search results in a report. the criteria are
> entered in the header and the detail section displays the results.
>
> I changed the record source to include all 3 queries and picked up the
> fields that I want on my form. However, searches I and II above, pull in no
> data. I am only able to search in III that has info in the header and detail
> sections. any suggestions?
>
> --
> Thanks, Karen

Thanks J.,
I kept the forms separate and generate a pop-up switchboard instead.
--
Thanks, Karen


"J" wrote:

> Hello Karen:
>
> You need to separate your data sources! You need one main form and
> 3 subforms. The easiest way to do this is to copy your existing form
> into 3 forms. Then individually delete all but one of the 'forms'
> within each of those forms and shrink them down to size. Then create
> the main form with the 3 subforms in it. When it asks you to link
> fields, just ignore it.
>
> Personally, I would make 3 different forms and then set them all to
> "Popup" but not "Modal". Then I would have a "starter form" that runs
> at startup, opens the 3 forms for you, positions them on the screen,
> and closes itself. That way the user can rearrange the 3 forms he/she
> has open.
>
> Good luck!
> ~J
>
>
> Karen wrote:
> > I want to see 3 different sections on a form called Project History, each
> > section performs it own searches and I want them to work independently of
> > each other - I already have these sections created but my problem is listed
> > below:
> >
> > I) a search by project number that allows user to enter project number and
> > click a button to bring up the info from the report; the search happens in
> > the detail section of the form.
> >
> > II) a search for pending files that allows user to view and print a report
> > of all pending projects, he can also input a project number and search for it
> > alone after clicking on a command. search happens in detail section of form.
> >
> > III) user enters a start and end date to search on projects' award dates. a
> > command button displays the search results in a report. the criteria are
> > entered in the header and the detail section displays the results.
> >
> > I changed the record source to include all 3 queries and picked up the
> > fields that I want on my form. However, searches I and II above, pull in no
> > data. I am only able to search in III that has info in the header and detail
> > sections. any suggestions?
> >
> > --
> > Thanks, Karen
>
>