Dear All
My report open event has the following code

Private Sub Report_Open(Cancel As Integer)
Dim strDocName As String
strDocName = "frmReportFilter"
DoCmd.OpenForm strDocName, acNormal, , , , acDialog
End Sub

How I do disable, lock or hide some controls over the said form,
because my form is also used for filtering some other reports where I
don't need some control

On 15/12/2010 13:38:55, Shakeel wrote:
Very confusing.

Let me get this right. You open a report, then that opens a form on which you
wish to hide or lock controls. What changes which controls are visible or
hidden, locked or unlocked. Does it depend on which report is open. As I
said, very confusing because the normal way is to open a form first and
generate a report based on the form's data

Phil

Use the openarg parameter to pass the form a flag. Then use the form's on
open event to modify the controls.

"Shakeel" wrote in message
news:c1a72fcc-5636-468b-8866-5adf88c0e96f (AT) l34g2000pro (DOT) googlegroups.com...

Dear All
My report open event has the following code

Private Sub Report_Open(Cancel As Integer)
Dim strDocName As String
strDocName = "frmReportFilter"
DoCmd.OpenForm strDocName, acNormal, , , , acDialog
End Sub

How I do disable, lock or hide some controls over the said form,
because my form is also used for filtering some other reports where I
don't need some control

On Dec 15, 8:20*pm, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote:
Dear Phil

yes the it is the normal way to open a form first and generate a
report based on the form's data, my form contains 6 text boxes for
filtering the report on the basis of data provided in the text boxes,
as I am using this form to filter data for almost all my reports, some
of the reports needs three parameter some needs four & some needs all,
so I want want to disable or hide unused text box on the form when it
is open for a particular report.

You've described nothing that would make it difficult to open the form
first, choose from a list box the report you want to open, obtain from
another column of the list box (or hard code, if you must) the controls that
should be shown for that report, then when the user has done his/her part,
open the selected report.

Larry Linson, Microsoft Office Access MVP


"Shakeel" <shakeel.678 (AT) gmail (DOT) com> wrote

On Dec 15, 8:20 pm, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote:
Dear Phil

yes the it is the normal way to open a form first and generate a
report based on the form's data, my form contains 6 text boxes for
filtering the report on the basis of data provided in the text boxes,
as I am using this form to filter data for almost all my reports, some
of the reports needs three parameter some needs four & some needs all,
so I want want to disable or hide unused text box on the form when it
is open for a particular report.