Report with buttons to open forms

[Donna]

Is it possible have a report which is from a query (which is based on
numerous other queries) that has buttons to open a specific form for each
record on the report?

I would like users be able to open the report and select a button which
opens a specific form based on the results shown on the report.

Any suggestions would be appreciated. Thanks.

 

[Al Campagna]

Donna,
Reports don't support functional buttons, nor their events.
Your best bet is to create a form that lists your records, and
use a button on it , to call a form for a specific value.
You should be able to use the same query used on your current report to
feed the form.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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

 

[Donna]

Al,

That's what I was afraid of as far as functional buttons on a report.

I already created a form for that purpose, but I needed to also have the
records numbered in sequential order and could not find a way to do that on
the form, so I went with a report.

Is there a way to show the records sequentially numbered on a form?

Thanks for your help.

 

[Donna]

Is it possible to have the functional button call a different form for each
different record?

Thanks again.

 

[Al Campagna]

Donna,
Why do you need to sequentially number your records?

If it's used to identify a particular record, for purposes of filtering
a report, that would be better handled by an Autonumber field in your table.
Since it would be calculated, and change as sorting changed, it would be
useless as a record identifier.

--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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

 

[Donna]

Al,

I need to be able to rank order these records each time the query is run as
the order may change throughout the day as users call up the form.

 

[Al Campagna]

Donna,
Tell me about the fields in your records.
Do you have a field that you are sorting on?
Let's say that each record has unique CustID autonumber field, and the
records are sorted by that value...
CustID
23
31
32
33
47
etc...
Then a calculated field ([SeqNo]) with... (use your own field/object
names)
=DCount("CustID","tblYourTable","CustID < " & CustID)
CustID SeqNo
23 1
31 2
32 3
33 4
47 5
etc...
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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