Designing a Search Form (Access 2002)

[hottoku]

Hi All,

I'm having quite a bit of trouble designing a search tool to work with
my database. I have found lots of examples from Microsoft Templates
to Allen Browne's sample search form. The latter looks very
promising, but I need to incorporate a combo box with "Nurse Care
Managers" and have it filter by this. (Right now, I'm being asked to
enter a parameter value and I can't figure out how to fix this.)

I need to be able to search with any combination of the following
fields, preferably with incomplete first and last names (if possible).

Last Name (text box)
First Name (text box)
Date of Birth (text box)
SSN (text box)
Nurse Care Manager (combo box with list from a query)
Referred date "From" and "To" (text box)

I think Allen Browne's search form will work well, but I am having
trouble getting my Nurse Care Manager dropdown to work. If I want to
bring up a list of all nurse AH's patients, if I type "AH" in the
"Enter Parameter Value" box, it works. I know this can be avoided,
but I can't remember how to fix it. A Yes/No field and combo example
is given; I think I just don't know what the code is supposed to look
like for just a combo example.

Any help would be much appreciated!

Audra

---
Allen Browne's sample search form can be found here:
http://allenbrowne.com/ser-62.html

[Salad]

hottoku wrote:

Hi All,

I'm having quite a bit of trouble designing a search tool to work with
my database. I have found lots of examples from Microsoft Templates
to Allen Browne's sample search form. The latter looks very
promising, but I need to incorporate a combo box with "Nurse Care
Managers" and have it filter by this. (Right now, I'm being asked to
enter a parameter value and I can't figure out how to fix this.)

What is the SQL for the combo? Have you created the combo? Where are
you being asked to enter a parameter value?

Bottom line. Does your combo work? Does it drop down some rows? If it
doesn't, go to the property sheet for that field and cut/paste your SQL
for us to review.

If it does, does it fail when you start searching?

I think that for a solution you need to think your problem out and
describe it better.

I need to be able to search with any combination of the following
fields, preferably with incomplete first and last names (if possible).

Last Name (text box)
First Name (text box)
Date of Birth (text box)
SSN (text box)
Nurse Care Manager (combo box with list from a query)
Referred date "From" and "To" (text box)

I think Allen Browne's search form will work well, but I am having
trouble getting my Nurse Care Manager dropdown to work. If I want to
bring up a list of all nurse AH's patients, if I type "AH" in the
"Enter Parameter Value" box, it works. I know this can be avoided,
but I can't remember how to fix it. A Yes/No field and combo example
is given; I think I just don't know what the code is supposed to look
like for just a combo example.

Any help would be much appreciated!

Audra

---
Allen Browne's sample search form can be found here:
http://allenbrowne.com/ser-62.html