VBA to open report from form

[Desmondo]

In the past I have always used macros but am trying to break the habit and have got stuck. I have searched and searched but must be missing something. I am trying to open a report from a button on a form however, the report shows all records not the one I am trying to specify with the [ID_Student] primary key. Heres the code I have;

stLinkCriteria = "[ID_Student]=" & Me![ID_Student]


DoCmd.OpenReport "r-StudentProfile", acViewPreview, , , , "[ID_Student]=" & Me![ID_Student]

Any help would be appreciated.

*I found the problem, right after posting this... to many commas after acViewPreview,, should have only been 2. Being a VBA newbie perhaps someone could explain the significance of the commas, cheers.

[June7]

Each comma separates an argument of the OpenReport method. Some arguments are required, such as the report name. For others, if no argument provided, default will be applied. The WHERE CONDITION argument is the 4th argument in the sequence, therefore 3 commas.

This convention will be applicable to many function and method calls.