Referencing form name and control in a procedure

[Jerry Call]

I've sent you a copy of my database, but don't bother looking at it, because nothing
I'm bringing up here is in it on your end.

I need to reference the value in a textbox on a form in a procedure, and I can't seem


to get some of the syntax right. Let's say the form is frmSodaTallyS. Here's the
relevant parts of its AfterUpdate event.

[code]
Dim TargetForm As Form
Dim CollectUndo As Control
Set TargetForm = Screen.ActiveForm
[Code]

Screen.ActiveForm correctly returns "frmSodaTallyS." But I can't get its name into
TargetForm.

I want to end up with--

[Whatever returns frmSodaTallyS].Controls.CollectUndo.Value

CollectUndo is a Long because it's a number, so I assume Value is the right word.

[CJ_London]

try

dim myLong as long
myLong=Screen.ActiveForm.CollectUndo

[June7]

Code is in form AfterUpdate event? Why use object variables and not simply: Me.CollectUndo

Value is default property for data controls so is not necessary to reference it.

[Jerry Call]

Thank you! I believe I've now got everything working, so close out this one.