ms-access parameter value query

[de_ja]

Hi,

If, for example an access database that concerns insurance claim
investigations.

The database comprises only one table containing data - investigation
reference number, referral date, referral source, investigation
commencement date, forename of claimant, surname of claimant, address1
of claimant, address2 of claimant, postcode of claimant, comments,
investigation end date, outcome etc etc.

All of this data is displayed in one "sheet", all the information
relating to the investigation can be seen at once.

In my database I have successfully implemented a parameter value query
that requires a user input and this returns the result in the
datasheet view.

What I want to do is to have the results displayed in the form view
(as mentioned above) displaying all of the data relating to that
particular parameter value.

Please could someone advise me or point me to a resource that explains
how to achieve this.

Thanks very much

Z

[Allen Browne]

Re: ms-access parameter value query

What do you want to search on?

If it is just one unique field (such as the reference number), and there are
only a few thousand of them, you could use this simple technique:
Using a Combo Box to Find Records
at:

http://allenbrowne.com/ser-03.html

If you want to be able to choose one field (any field, but only one at a
time), and then filter the form to match what you type, see:
Find as you type - Filter forms with each keystroke
at:

http://allenbrowne.com/AppFindAsUType.html

This is copy'n'paste stuff, i.e. you don't need to change the code to use
it.

If you want to provide a form where the user can enter several things at
once (e.g. date range and claimant surname), see:
Search form - Handle many optional criteria
at:

http://allenbrowne.com/ser-62.html

This one does require some coding, but includes a sample database for you to
download, pull apart, and see how it works.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"de_ja" <de_ja@hotmail. co.ukwrote in message
news:aee10330-f100-40e5-b295-2cb6001559e7@c5 8g2000hsc.googl egroups.com...

>
If, for example an access database that concerns insurance claim
investigations.
>
The database comprises only one table containing data - investigation
reference number, referral date, referral source, investigation
commencement date, forename of claimant, surname of claimant,
address1 of claimant, address2 of claimant, postcode of claimant,
comments, investigation end date, outcome etc etc.
>
All of this data is displayed in one "sheet", all the information
relating to the investigation can be seen at once.
>
In my database I have successfully implemented a parameter value
query that requires a user input and this returns the result in the
datasheet view.
>
What I want to do is to have the results displayed in the form view
(as mentioned above) displaying all of the data relating to that
particular parameter value.
>
Please could someone advise me or point me to a resource that
explains how to achieve this.
>
Thanks very much
>
Z

[de_ja]

Re: ms-access parameter value query


Thanks very much Allen,

I will have a look at your sites later.