Hi Marwa,
Welcome :)
adding on to Bill's advice ... another advantage of driving with a form is that a report can be put onto a form in a subform control. Forms are best for controlling what happens.
Get some ideas by watching this video:
Access 2010: Add a report to the Report Center in an Access web database template
by chris Downs
http://www.youtube.com/watch?v=lJKdRaK5TkI
Even if you do not have Access 2010, this functionality can be implemented in lower versions by changing the SourceObject of a subform control to the chosen report
A section of the form can be for criteria. If there is a lot of criteria, I find it easiest to use a report menu form with buttons to open reports using the relevant criteria
Warm Regards,
Crystal
*
(: have an awesome day :)
*
--- On Mon, 8/29/11, Bill Mosca wrote:
> Marwa
>
> Reports are not really designed for buttons. The more
> accepted way is to use a form that has the same data as the
> report. That would eliminate the need to open another form
> unless that record has more data than is present on the
> report as it stands now.
>
> You can always print the report itself as needed, but for
> viewing that includes editing a form is the way to go.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
> --- "Marwa Abo Amra" wrote:
> >
> > Hi All,
> >
> > I have a database and I have created a form form a
> table and created a report from a query that is created from
> the same table. Now, I need to have a button on the report
> that can open the record in the form so I can edit or add
> data. I have created a button on the report design view and
> used macro action as follows:
> > Action : OpenForm
> > Argument: FormName, Form, , [FieldName] =
> Forms![FormName].[FieldName], Edit, Normal
> >
> > When I run it, the form opens to a new entry and no
> data are shown.
> >
> > I need to open the same record on the form as the
> record I am clicking button from the report.
> >
> > Any ideas please.. Any help will be greately
> appreciated.
> >
> > Thank you
> >
> > Marwa
> >
>
>
Tidak ada komentar:
Posting Komentar