Form Over Report

G

GracieLou

I hope I am posting this in the correct spot. I almost posted in Forms.
We'll see.

What I really want to accomplish is a drilldown. Right now a user clicks a
button that brings up a report that shows them summary account data. What I
want to do is to put a toggle button along side of the account number. When
the user cllicks on that toggle button i want to show the detail that made up
the original summary for that account. I know this cannot be done using
Reports(?). But I was thinking maybe I could overlay the Report with a
sliver of a form that would show a toggle button beside each account number
in the report. I could put code behind the toggle button so when a user
clicks on this toggle button it would then show the detail data.

So far, I have not figured out just how to do this. Is it even possible?

I tried using Forms to do this. I have 823 accounts. I showed them on a
continuous form. I put a toggle button on the detail line. Problem with the
Form; wheneveeer you click the toggle button next to an account, all of the
toggle update.

Any suggetions?
 
S

strive4peace

Hi Gracie,

are you just wanting to pick one account or several? If you
want to choose more than one, you will need something like this:

add the following field to the table with your account numbers:

Flag, yes/no

then, on your form, make a checkbox field bound to Flag --
then the choices will be stored with each record

you can then use the Where clause of the OpenReport action
to filter for the flagged fields

'~~~~~~~~~~~~~~~~~~~~`
If you just want to choose one account, you can make a
command button to open the report for the account number on
the current record


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
Top