Jump from a report to a specific record

[sagamw]

I have this idea.
It's not obligatory to my form but if i find a simple way to do it, i maybe implement it.

Let's say we have a report that serves as a list of records.
I want to be able to click on a line of my report and jump to the main form with the full record.

I think the crucial step is how can I retrieve the id of the line (record) I clicked.

Any Ideas?

 

[RuralGuy]

A report is a piece of paper and not interactive but you can do what you want with a form.

(RG for short) aka Allan Bunch MS Access MVP acXP ac07 ac10 winXP Pro Win7 Pro
Please respond to this forum so all may benefit

 

[sagamw]

I guess you mean a continuous form.

I don't know about the report being "a piece of paper" though.
There are events like onclick etc. for all the fields in the detail part of a report.
I don't see why can't this be interactive.

The 1st step must be to retrieve the id of the line/record though.

After that it's relatively easy.

 

[RuralGuy]

Have you been successful at getting any of those control events to do anything on a report?

(RG for short) aka Allan Bunch MS Access MVP acXP ac07 ac10 winXP Pro Win7 Pro
Please respond to this forum so all may benefit