I think that you are on the right path, but there seems to be other
factors that I still need to take care of here. I have been told by the
future users that they need to be able to search for candidates, for
entry and reporting. A common reason is that a partner in the firm may
come to them and say "remember that candidate that went to Harvard?" if
that is all the info that they have, or they are only given 1 piece of
info, then they need a full search form.
My search form is unbound, and the subform with results is bound to a
query which has all fields a person might want to search on.
I like the idea of a combo box, but also, the reason for a candidate
report button on the entry form is not for printing. They usually
wouldn't want to waste paper or take the time to pick up a print. a
report is an easy way to see all of a candidate's info in one place, and
quickly close it. They can also then choose to print or pdf and email
to anyone ie the partner requesting the info.
Also, even with this method, I still need to take care of the criteria
on the backend of the report. I am not used to using code for a report,
so I even though I can imagine what it would be, I am not sure where i
would put it.
I have the report ( which has a bunch of subreports; that shouldn't
matter) and it is bound by the query builder.
I would think that I would do something like
if frmfindcandidate.isopen then
candid = candid
else
candid = forms!frmcandidateentry!candid
end if
something like that.
Anyway. I really want to figure this out from the perspective of this:
How does one use 1 form and 1 report in multiple places, controlling
where it grabs and places stuff based on how it was activated etc.
Thanks for the ideas. I will look at the app again on Monday to see
what I may be able to reconsider from your advice. It does make some
sense. I think I wasn't expecting to hear that my plan was overkill,
because I see programmers use these methods so often.
misscrf
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!