[MS_AccessPros] Open Form from a Report

 

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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3
• New Files 3

Visit Your Group

MARKETPLACE

A bad score is 596. A good idea is checking yours at freecreditscore.com.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___