CODEWITHSUNDEEP
ms-accessvbams-access-2010
Marchese Il Chihuahua
Marchese Il Chihuahua

Reputation: 1139

Creating a zoom in control on a report

I am trying to build a pop up zoom box which will be activated on a report embedded in a form allowing the user to click on the report and view a field on the underlying table which the report is demonstrating. Furthermore, the user will also have the opportunity to edit the fields contents which the zoom box, upon closing will then paste into the field in the underlying table.

A colleague of mine confirmed for me that this is possible and put me on the right track by showing me that it is possible to extract a field by creating a control on a report. However, i am missing the part to repaste the updates into the underlying field.

Being a report, Sift F2 does not allow the edit..

I would appreciate any advice available. Thanks, A

Upvotes: 0

Views: 310

Answers (1)

Marchese Il Chihuahua
Marchese Il Chihuahua

Reputation: 1139

Fantastic effort given by HansUp in live chat directing me to exactly what i needed!

DoCmd.OpenForm "frmZoom2", WhereCondition:="[ID] = " & Me.txtPrimaryKey

Upvotes: 2

Related Questions