Passing along a name from a form.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a drop down box on my reports form page that contains a list of my
employees. What I would like to do is to select a name from the box, then
click on the report I want for that individual. Right now I have the
reports but I have to type in the name that I want for it to work. Can you
steer me in the right direction.

Thanks
 
Todd,
How are you now entering the Name? Do you enter into a field on the
form, or do you have a parameter query that requests the name, via an input
box, just as the report runs?
If you enter it into a field on the form... then just change that field
to a combo box.
If a parameter query, remove the parameter from the report query, and in
that query use this as a criteria for the Name field...
=Forms!frmYourFormName!cboYourNameCombo
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

photo on a form 4
Excel Concatenate Form Name to Parse for function 1
Report list in a drop-down box 8
Drop-down list that only shows relevant reports 3
Names for a Report 5
Creating Forms from Tables 11
Limiting a drop-down list of reports 2
Use form to select criteria for report 4

Back
Top