Senin, 29 Agustus 2011

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

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar