Using controls with Reports

[Cedarguy]

It appears that you can use controls with Reports in Access 2010 otherwise the ribbon wouldn't present them.



I tried using a button on a report so I could select the record displayed on a row, to invoke an existing form, so I could edit the record.
I used the OpenForm macro that's invoked when the button is clicked.
I provided the condition which equates the record ID field on the report with the same field on the form.
The mechanism seems to work (i.e. I can invoke the form) but the form either starts with the first record on the table (when I provide the condition) or a bank form (when a condition is not provided).

So, are control supposed to work with reports?
If so, any suggestions as to how I can make this work?

Many thanks.

[June7]

Report doesn't have record selector so don't know if this is possible. Have you step debugged? Do you know the ID value is passed to the code that opens form?

Review link at bottom of my post on debug techniques.