Visible property

I have a "Report Dialog" form that is called when a report is opened. The "Report Dialog" has several parameter text boxes. Would like to set one or more of those boxes to "visible=false" depending on the report calling the "Report Dialog".

Currently using the code below to call the ReportDialog form:

Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "ReportDialog", , , , , acDialog

If Not IsLoaded("ReportDialog") Then
Cancel = True
End If

End Sub

Thanks

Ernest L. Kendricks

once you have the form open do this

The way you manipulate forms from another form is like this

after DoCmd.OpenFrom .... blah blah blah

type

Code: Select all

with Forms("FormName")
  if condition1 then
     .form.controlName1.visible = false
  elseif condition2 then
     .form.controlName2.visible = false
     .form.controlName3.visible = false
  end if
end with

You may want to use a SELECT CASE statement if there are several options. They are more efficient.

one thing to keep in mind is that these changes will be saved when the form is closed, so you either need to set all the controls to visible when you open the form, close the form, or in the above code.

jakyra