If Statement Referencing Sub-Forms

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dave Elliott (dontgetshocked_at_sbcglobal.net)
Date: 02/15/05 

Date: Tue, 15 Feb 2005 23:01:55 GMT

I have two text boxes on my main form which have as there control source
controls on a sub-form on the main form.
They Reference the sub-form FTimeBillingSub
I want the code to run on another sub-form on the main form named
Vendor_List. (Main form is named TimeCards)
Right now I am trying to run the code on the get focus event of the first
control on the Vendor_List sub-form.
There is no message box. Both text boxes, text412 and text414 are in
currency format
So if Text412 has a value greater than 0 and Text414 equals 0 then MsgBox
"yada yada"
Suggestions????

If ([Text412]) > 0 And ([Text414]) = 0 Then
MsgBox "Why is there more material on this job?"
End If

Relevant Pages

  • Re: Query too large
    ... but to NOT fill the source object of the sub-form control. ... through the onChange event of the tab control, and the actual active page is ... subform (see the Form property RecordSource, in design mode of the said ...
    (microsoft.public.access.queries)
  • Run-time error 2110 in form when using setfocus
    ... -the first sub-form control ... -the second sub-form control ... to the control sfrmPersonPhone. ... Private Sub txtTabToPhone_GotFocus ...
    (microsoft.public.access.formscoding)
  • Re: Nested Continuous forms
    ... Thanks, I have been using the Properties Sheet, but also the little pop-up ... those link master/child fields in..else you could not yet linked anything!!! ... on, combo box controls on, and also sub-form control. ...
    (microsoft.public.access.forms)
  • Re: Nested Continuous forms
    ... How then have you been setting up the linking then? ... those link master/child fields in..else you could not yet linked anything!!! ... on, combo box controls on, and also sub-form control. ...
    (microsoft.public.access.forms)
  • Re: How to syncronize a datasheet form and single form?
    ... If I remove the bottom form (the single form) ... >> Yada, yada, yada... ... sub-form control can ... and EACH sub-form control can be the SAME form! ...
    (microsoft.public.access.forms)