Re: Unexplained label behavior

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

From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 09/07/04 

Date: Tue, 7 Sep 2004 18:05:35 -0400

Sounds as if there is a timing issue here...your code is running faster than
the form can load its data.

Is your code running in the main form's Load event procedure? If yes, try
moving the code for setting the values to the form's Activate event. If that
doesn't work you might try using the Current event of the subform that runs
the query. 

-- 
        Ken Snell
<MS ACCESS MVP>
"Dave the wave" <Bogus1@softhome.net> wrote in message
news:n4ednQiubtc-tqPcRVn-ig@adelphia.com...
> I have a form with 2 subforms. The first subform displays based on an SQL
> statement. The second is in the footer of the main form and is only there
to
> display 2 summary numbers from a separate query.
>
> At first I used text boxes and set their values from a query. The problem
> was that (even with the tab stops set to no) when the form loaded the
cursor
> would hide the value. So I added 2 labels to the subform, 2 lines of code
to
> set the labels to the text box values and figured the problem was solved.
>
> When I open the form neither label has a value. If I make the code break
and
> then step through (using F8) the code the values appear as expected????
I've
> thrown in some MSGBOX commands to display the values of the text boxes and
> sure enough they are blank, unless I step through the code????
>
> TABLE/FIELD:
> Repacks/RepackNumber (reference number for each investigation)
> Repacks/RepackTotalCases (number of cases involved.)
>
> FORMS:
> frmIReview [no record source] just a container form.
>
> SUBFORMS:
> sfrmIReview (which is working fine) no link between frmIReview and
> sfrmIReview.
> sfrmRepackTotals [record source = Repacks]
>
> LABELS:
> lblTotalCases=Sum([RepackTotalCases])
> lblTotalInvestigations=Count([RepackNumber])
>
> TEXT BOXES:
> tbxRepackTotalCases
> tbxTotalInvestigations
>
>
> Here is my code:
> Private Sub Form_Load()
> Me.lblTotalCases.Caption = Me.tbxRepackTotalCases
> Me.lblTotalInvestigations.Caption = Me.tbxTotalInvestigations
> vartemp = MsgBox("Total Cases " & Me.tbxRepackTotalCases, vbOKOnly)
>
> End Sub
>
> I left one of the MSGBOX lines in to show how I was trying to determine
what
> the text box value was. If I step through the code the value is set,
> otherwise the text box does not contain a value.
>
> If anyone might suggest where the problem lies, or knows of a better
> way.....I am all ears and very grateful.
>
> -- 
> from
> Dave the wave~~~~~
>
>

Relevant Pages

  • Re: How to set the recordset of a subform of a subform?
    ... Thank you tina, ... recordset because i can't specify the path to the level 3 subform..... ... but i will create it before the parent form load. ... I find that the level 3 subform can locate the source correctly. ...
    (microsoft.public.access.forms)
  • RE: SourceObject and RecordSource
    ... nested up to 4 subforms deep in a couple of places, but that usually filters ... When I first created the form, it took over 2 minutes to load. ... I loaded all the list boxes without row sources. ... records and is filtered based on the current row on subform 1, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Unexplained label behavior
    ... After the error message box was closed the values appeared as expected. ... What I don't understand about the problem being timing is that this subform ... I decided to create a Summary Query and used the Count and Sum values to ... So I added 2 labels to the subform, ...
    (microsoft.public.access.formscoding)
  • Re: Does loading additional forms drain resources?
    ... a tab control to display subform records, you don't need a subform control ... on each tab. ... In most cases you should be able to get your form load time down to ... One great tip is to not load sub forms until you need them. ...
    (microsoft.public.access.forms)
  • Re: Loading order of main form and subform
    ... Set the SourceObject and/or the Recordsource in code after you set the Main ... > main form is supposed to load with data as is the subform. ...
    (microsoft.public.access.forms)