displaying certain records in a report

[Jason1]

Hello all,

I am running Access 2007. I have a report that is based on a table. The report show the productivity of different employees. I want to use a form to pull the same report, but only display the employee that is selected on the form.

I have made it work using a text box, but when I use a combo box tied to my empolyee table, it doesn't work.

I am new to this, and feeling my way through it. I would like to know how the access programmers who know what they are doing solve this problem, as opposed to me just figuring out a way to make it work.

thanks for the help,
Jason

 

[pbaldy]

I often use this technique:

http://www.baldyweb.com/wherecondition.htm

Making it work with a combo vs a textbox is generally a matter of making sure the bound column of the combo returns the appropriate value, or using the Column property of the combo to get the right value.

 

[Jason1]

That fixed it. It was looking at the wrong column.

Thanks

 

[pbaldy]

Happy to help.