Form Over Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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

*
 
Back
Top