Re: If Statement Referencing Sub-Forms
From: Dave Elliott (dave_at_dontgetshocked.com)
Date: Wed, 16 Feb 2005 13:44:21 GMT
This code still does not work???
TimeCards is the main form and code is being run from a sub-form named
If Forms!frmTimeCards.Text414 >0 and Forms!frmTimeCards.Text416 =0 Then
MsgBox "Why is more material being put on this job"
"Wayne Morgan" <email@example.com> wrote in message
> "Me." is shorthand for the form that the code is running on. From the
> Immediate Window you would have to specify the full path to the Parent
> form instead of Me, then give the path from there if you are referring to
> a subform.
> Also, you need to specify the full path to both textboxes.
> Wayne Morgan
> MS Access MVP
> "Dave Elliott" <firstname.lastname@example.org> wrote in message
>> Error says Variable not yet created in this context in immediate window
>> If Me.Parent.[Text412] > 0 And [Text414] = 0 Then
>> MsgBox "Why is there more material on this job?"
>> End If