Report with buttons to open forms

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.
--
Donna N.

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" wrote in message
...
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.
--
Donna N.

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 N.


"Al Campagna" wrote:

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" wrote in message
...
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.
--
Donna N.


.

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

Thanks again.
--
Donna N.


"Al Campagna" wrote:

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" wrote in message
...
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.
--
Donna N.


.

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" wrote in message
...
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 N.


"Al Campagna" wrote:

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" wrote in message
...
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.
--
Donna N.


.

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.
--
Donna N.


"Al Campagna" wrote:

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" wrote in message
...
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 N.


"Al Campagna" wrote:

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" wrote in message
...
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.
--
Donna N.


.



.

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."

"Donna" wrote in message
news
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.
--
Donna N.


"Al Campagna" wrote:

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" wrote in message
...
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 N.


"Al Campagna" wrote:

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" wrote in message
...
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.
--
Donna N.


.



.