Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
date: Thu, 9 Oct 2008 08:44:14 -0700,    group: microsoft.public.access.reports        back       


Drop Down Box   
I created a report that displays a specified health record, the user types in 
the health record number and then the report comes up with all the 
information.  I would like to create a drop down box on the report which 
would allow the user to select the manager/technician that filed created the 
report to be submitted.

Is it possible to do this?

Thanks.
date: Thu, 9 Oct 2008 08:44:14 -0700   author:   Thorson

Re: Drop Down Box   
Thorson wrote:

>I created a report that displays a specified health record, the user types in 
>the health record number and then the report comes up with all the 
>information.  I would like to create a drop down box on the report which 
>would allow the user to select the manager/technician that filed created the 
>report to be submitted.


Report's are not interactive (at least through A2003) so No
you can't do that.  That kind of thing should ne done in the
form that opens the report.

I haven't used A2007 enough to know if that has changed.

-- 
Marsh
MVP [MS Access]
date: Thu, 09 Oct 2008 13:22:31 -0500   author:   Marshall Barton

Re: Drop Down Box   
I am actually using access 2003, so that answers my question.  That is fine 
I'll have to do it another way.  Thanks!

"Marshall Barton" wrote:

> Thorson wrote:
> 
> >I created a report that displays a specified health record, the user types in 
> >the health record number and then the report comes up with all the 
> >information.  I would like to create a drop down box on the report which 
> >would allow the user to select the manager/technician that filed created the 
> >report to be submitted.
> 
> 
> Report's are not interactive (at least through A2003) so No
> you can't do that.  That kind of thing should ne done in the
> form that opens the report.
> 
> I haven't used A2007 enough to know if that has changed.
> 
> -- 
> Marsh
> MVP [MS Access]
>
date: Thu, 9 Oct 2008 11:34:02 -0700   author:   Thorson

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us