records as links on reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maax - 17 Apr 2007 10:44 GMT

Hi all,
is it possible to click on a record that is displayed in a
report and have it open that record for editing?

many thanks

Reply to this Message

Al Campagna - 17 Apr 2007 14:46 GMT

Maax,
No. Objects on a report have no events (OnClick, OnDbl-Click, OnEnter, etc...)

Signature

hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

> Hi all,
> is it possible to click on a record that is displayed in a
> report and have it open that record for editing?
>
> many thanks

Reply to this Message

Maax - 17 Apr 2007 15:14 GMT

ok Al, thanks for reply. i will have to think of another way.

> Maax,
> No. Objects on a report have no events (OnClick, OnDbl-Click, OnEnter, etc...)
[quoted text clipped - 3 lines]
> >
> > many thanks

Reply to this Message

Carl Rapson - 17 Apr 2007 15:38 GMT

You can make a form that looks a lot like a report, and handle the events
there.

Carl Rapson

> ok Al, thanks for reply. i will have to think of another way.
>
[quoted text clipped - 6 lines]
>> >
>> > many thanks

Reply to this Message

Maax - 17 Apr 2007 15:48 GMT

Hi Carl, yes that was my initial thoughts. I am using Access 2007 and have
used the function where you can turn a query into a report very easily. Is it
possible to use a report to generate a form? I will give it a go.

> You can make a form that looks a lot like a report, and handle the events
> there.
[quoted text clipped - 11 lines]
> >> >
> >> > many thanks

Reply to this Message