Allowing users to create a report

[your2slow]

Before I ask my question I've been reading through this group and have
found many helpful info, so I wanted to say thanks to everyone. I've
been stuck on one thing though. I've got a database that keeps track
of all our Computer Inventory (serial numbers, who owns it, ip address,
mac, etc.). What I'm looking to do is allow the user to chose a button
from the SB that will allow them to customize the report. Example:

1. User clicks on button,
2. Then another screen pop's up saying. "What Coordinator or Incident
number do you want to display" (we assigned incident numbers to each
Coordinator)
3. User types in what they want. "Joe" (or they can type the incident
number)
4. Report spits out all the info i've added in the queries for Joe.

Not sure if this is enough detail but any help with this would be
great.

 

[Guest]

1. Clicking on the SB button brings up a form named frmReportInput.
2. frmReportInput has 2 unbound text boxes and a button.
3. User types in what they want and then clicks the button.

4. Here's where the magic happens!
- Create the frmReportInput with two unbound text boxes named
txtCoordinator and txtIncident.

- On the same form create a button the runs the report. The wizard should
help. For extra bonus points make the button also make the from invisible.

- Modify the query that populates the report.

-- In the criteria of the Coordinator field put:
[Forms]![frmReportInput]![txtCoordinator]

-- In the criteria of the Incident field put the following one line lower
to make it an Or statement:
[Forms]![frmReportInput]![txtIncident]

Try it and see what doesn't work right the first time. Fix it or ask more
questions here.

 

[your2slow]

Thanks Jerry. I'll give this a try and post back

1. Clicking on the SB button brings up a form named frmReportInput.
2. frmReportInput has 2 unbound text boxes and a button.
3. User types in what they want and then clicks the button.

4. Here's where the magic happens!
- Create the frmReportInput with two unbound text boxes named
txtCoordinator and txtIncident.

- On the same form create a button the runs the report. The wizard should
help. For extra bonus points make the button also make the from invisible.

- Modify the query that populates the report.

-- In the criteria of the Coordinator field put:
[Forms]![frmReportInput]![txtCoordinator]

-- In the criteria of the Incident field put the following one line lower
to make it an Or statement:
[Forms]![frmReportInput]![txtIncident]

Try it and see what doesn't work right the first time. Fix it or ask more
questions here.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Before I ask my question I've been reading through this group and have
found many helpful info, so I wanted to say thanks to everyone. I've
been stuck on one thing though. I've got a database that keeps track
of all our Computer Inventory (serial numbers, who owns it, ip address,
mac, etc.). What I'm looking to do is allow the user to chose a button
from the SB that will allow them to customize the report. Example:

1. User clicks on button,
2. Then another screen pop's up saying. "What Coordinator or Incident
number do you want to display" (we assigned incident numbers to each
Coordinator)
3. User types in what they want. "Joe" (or they can type the incident
number)
4. Report spits out all the info i've added in the queries for Joe.

Not sure if this is enough detail but any help with this would be
great.