Data field specific reports and combo boxes

[jaymaelescent]

I have been asked by worklace to try and make a database for them, i have some experience but have encountered a problem making user specific reports. I need to make a report based on a person stored within the data base showing a series of data where i single field is null,
So the things i need to know is:

*How to make a query to pull out only data related to a specific field
*How to make that field be that the report will be based on selectable from a combo box on running the query.

I can make combo boxes and can make macros bindings to buttons, and have a front end form already made. I am just having issues wrapping my head around the making of the actual report and being able to select the right person from the list. The people who will be using the database are not very familiar with access so it needs to be as user friendly as possible.

Thankyou for your time and help and i hope to hear from somebody soon

[NeoPa]

A report runs based on a data source (usually query or table).
When running a report it is perfectly possible to filter the data that is returned and processed.
A ComboBox for selecting the item to filter is the usual way to do something like this. Have a look in Example Filtering on a Form to see the concept in action.
Macros are not a very flexible or pwerful way to use Access. VBA code in modules gives better and more manageable results.
Let us know how you get on.

[jaymaelescent]

The example you gave does not comform with what i am trying to do at all. I have 3 tables a User table (with user number primary key), Job table (also primary keyed with a job number) and a tasks table (also with a task number primary key). I have crated a front end for the form which will be used by people have have next to no access experience at all. What i need to do is make a button on the front end (already made just not linked to anything yet) that when clicked will bring up a combobox for where they can select a person (based off the persons ID number in the user table) from the dropdown list and that will generate a report specific to the selected person ONLY. It will need to have data from the the tasks table sorted by the jobs in the job table. They will also need the reverse report, Unique to job type (job table) and sorted by user. This has been a thorn in my side for some time and i would appreciate any help if at all possible. I am not really familiar with visual basic so code isnt of much use to me unless it has explicit instructions on how to use it. Thanks for your time
Jay.

[NeoPa]

Jay,
Without code you can do basic database type things in Access. If you want to call reports with a filter which is controlled by selections on a form then the best way is certainly to use code.

A rather kludgy alternative might be to design the report itself to filter on the specific control within a form. I would certainly not recommend that approach but if that's what you choose to do I can possibly help you get there. It does mean that you will need to be very clear with what you have in your database. Proper names for all objects will be required and clear explanatioins of how it fits together. I can't promise even then that all requirements will be met, but we shoult be able to filter the report to a single user at least. I would stress that this is not a recommended approach.