Change unbound text box in Report using VBA language from form

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

I'm wondering if it is possible to change the contents of an unbound text box
in a Report by using VBA language from a Form.

Here's what I'm trying to do: When the user clicks on an Open Report
button, I would like the user to be able to choose if certain text is
displayed on the report or not. Then the Report should open. The certain
text I'm referring to is only saved in the VB code I've used in the Form that
he Open Report button is on. I can send code or give specifics if necessary,
but I was hoping that there was a simple solution that I was overlooking.
 
From VBA, you can access a control on an open form with the syntax:
Forms!FormName!ControlName, so, basically, you can, in the procedure
handling the Report Open event, you can check the controls of the form, and
turn on or off the visibility of some controls in the report, as example:



Private Sub Report_Open(Cancel As Integer)
If Forms!formOne!ShowLabel6.Value <> "OK" Then Me.Label6.Visible = False
End Sub



So, basically, it is (easier if it is) the report which does the
synchronization, not the form.

Note that you can write additional code, in the report, to check if the form
is actually open (and if not, bypass the code about it).


Vanderghast, Access MVP
 
Back
Top