Marwa,
If you are using Office 2007 or higher, you can put a button on the report in report view. Set the properties so it only shows on screen. But Bill is correct about using a form based on your specifications. I have used buttons on reports to filter the report based on the criteria I needed by department.
Jim Wagner
________________________________
________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, August 29, 2011 7:50 AM
Subject: [MS_AccessPros] Re: Open Form from a Report
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
--- In MS_Access_Professionals@yahoogroups.com, "Marwa Abo Amra" <m.statalex@...> 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
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar