Accessing a Textbox's Value from Another Form

[yu217171]

Hi everyone,

I'm trying to access Form1.TextBox1.Text from Form2. Someone suggested I try

msgbox Forms ("Form1").TextBox1

But I get

Runtime Error: 2465: Application-defined or object-defined error.

Can anyone help? Why can't I just do Form1.TextBox1.Text?!?

Keith

 

[cghoga]

Try...

Forms!Form1!TextBox1.text

or

Forms!Form1!TextBox1.value

Make sure Form1 is open in the background when doing this.

 

[striker73]

Does this work the same way with checkboxes? I am trying to set a checkbox on my form from my global VBA module and I'm getting Application-defined or object-defined error

My code is:

Forms!frmTesetReport.chkScanned.Value = True

What am I doing wrong?

 

[yu217171]

Hi,

I get The OpenForm action was canceled. I am trying to display the value

'In Form1
Private Sub btnSubmit_Click ()
   if not isNull (me![txtMediaID]) then
      DoCmd.OpenForm ("Form2") '<-- Error on this line
   else
      MsgBox ("Please select a media type")
   end if
End Sub

'In Form2

Private Sub Form_Load
   MsgBox "MediaID: " & Forms!frmMediaTracker!txtMediaDesc.Value
End Sub

Just for context ...

Keith