Button

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

Guest

I have tried different thread suggestions on how to print a report from a
form and put in several mods but nothing works. The text box comes up asking
me to type in the Employee Name. How can I just click on the button and have
it print out the employee who's form I have in front of me not all?

Thanks
 
SG,
Sounds like you have a parameter in the query behind the report, that
prompts for an Employee name every time the report opens.
Remove the parameter, and in the query behind the report use the
following criteria against the EmployeeName field...
=Forms!frmYourFormName!EmployeeName
That will filter the report for just the record you are viewing.

Note: You should probably be using a more "unique" identifier "key" field
to identify that particular employee... say something like a EmployeeIDNo.
In large databases, it would be possible to have 2 Bob Smiths.
So... =Forms!frmYourFormName!EmployeeIDNo would be better.
hth
Al Camp
 
I have tried different thread suggestions on how to print a report from a
form and put in several mods but nothing works. The text box comes up asking
me to type in the Employee Name. How can I just click on the button and have
it print out the employee who's form I have in front of me not all?

Thanks
Click to expand...

You have written here that you have tried different suggestions found
in various threads to do what you wish to do, but they haven't worked.
What is the point of asking for more suggestions (which will probably
be the same as the ones you have tried) when you haven't posted what
you have tried and what you mean by "doesn't work'? Do you get all the
records?None of the records? Some of the records? Access crashes?

Questions such as yours (to print out a report based upon the record
shown on a form) are answered in these news groups several times a
day. If you haven't found one that works perhaps you are doing
something wrong, in which case getting the same suggestions is not
going to help.

Exactly what have you tried?
What do you mean by 'doesn't work'?
 
Back
Top