Error 3162 doesn't make sense to me 1

[annie52]

Why does this code raise Error 3162 - You tried to assign the Null value to a variable that is not a Variant data type.

If Me.NewRecord Then
Forms![frmReqnWatch]![frmDisreps].Form![XrefReqnID]= Forms![frmReqnWatch]![ReqnID]
DoCmd.Requery
End If

I'm trying to pass the value from a text box in the main form to a text box in a subform Both are bound to numeric (long integer) fields in a table.

 

[Darrylles]

Hi Annie,

Are your object names correct?
[frmReqnWatch]
[ReqnID]
Make sure your form and textbox are actually named correctly.

If so, ReqnID contains a null value, e.g. ReqnID does not contain the ID that you are expecting.

ATB

Darrylle











Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[annie52]

Hi Darrylle. You were exactly right.

Forms![frmReqnWatch]![frmDisreps].Form![XRefReqnIDtoDisrepNum.ReqnID] = Forms![frmReqnWatch]![ReqnID]

Thanks so much for your feedback.