combo box/command button used to open a report: How?

[Guest]

I have a form with a combo box, based on a query showing the primary key
(StudentKey) and the student’s name. The combo box is bound to the first
column (StudentKey). The combo box is named “Keyâ€. Column widths are 0â€,1â€

I have a command button next to the combo box that I want to open a report
to show only the data for the student selected. The report has the
StudentKey field on it. I’ve tried several coding things with the “on clickâ€
event on the button, but nothing has worked properly. Here’s my latest try
(it generates the error that Access can’t find the field “|†used in the
expression).

Dim stDocName As String
Dim stLinkCriteria As Integer

stDocName = "Billings-AccountHistory"
stLinkCriteria = [StudentKey] = Me![Key]

DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

I know it has something to do with how I write the condition statement, but
I haven’t landed on the right way yet.

Thanks in advance.

Jerry

 

[Albert D. Kallal]

stDocName = "Billings-AccountHistory"

stLinkCriteria = [StudentKey] = Me![Key] close!!!

Try

stLinkCriteria = "[StudentKey] = " & Me![Key]

 

[Guest]

Got rid of the one error, now I'm getting a "type mismatch" error when I
click the button.

stDocName = "Billings-AccountHistory"
stLinkCriteria = [StudentKey] = Me![Key] close!!!

Try

stLinkCriteria = "[StudentKey] = " & Me![Key]

 

[Guest]

Fixed it. The stLinkCriteria variable was dim as an integer. Had to change
it to a string.

Got rid of the one error, now I'm getting a "type mismatch" error when I
click the button.

stDocName = "Billings-AccountHistory"
stLinkCriteria = [StudentKey] = Me![Key] close!!!

Try

stLinkCriteria = "[StudentKey] = " & Me![Key]