Can you help w/ a form?

[Guest]

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?

 

[J]

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

 

[Guest]

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