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