Re: Reference If Statement Result

Referencing the textbox itself is not a big problem; the bigger issue I see
here is that the second argument of DCount is not the name of a form, but
the name of a table or query. And the table or query, of course, doesn't
contain your unbound textbox.

One way of working around this would be to reuse the criteria in your IIF
statement for the DCount, instead of referencing the unbound textbox:
=DCount("*","MyTable","DatePaid<DateDue")

HTH

<hmiller@xxxxxxxxxxxx> wrote in message
news:1130647531.771920.321290@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I have created and IIF statement in an unbound text box. The IIF
> statement produces a text result, ie "On Time", in the unbound text
> box. What I would like to do is reffence this text box and then the
> result contained in the text box. Something like this:
>
> =Dcount("*","The form where the unbound text box is","TextBox='On
> Time'")
>
> How can I get this work work?
> Is it possible to reference an unbound text box? (I have read this box
> is no longer unbound seeing it has an IIF statement in it)?
> Is it possible to reference the result of an IIF statement?
>
> Any help is greatl appreciated.
>
> PS - Where is the best place to begin learning VBA. Most of the books I
> have read are way over my head.
>


.

Relevant Pages

  • Re: Reference a subform
    ... Allen Browne - Microsoft MVP. ... "Leonard" wrote in message ... >>> 'zoomed' to a bigger textbox on a popup form. ... >>> And, is this called explicit or implicit referencing, or something ...
    (microsoft.public.access.modulesdaovba)
  • RE: What is the meaning & use of "& ME!"?
    ... The "Me" keyword is a self-identifier for referencing a property or value ... This will place the name Bob inside the textbox that is on your form. ... form or the txtUserName field to something else, ...
    (microsoft.public.access.formscoding)
  • Re: reference problem
    ... referencing) that the tab control does not exist and the textbox is directly ... "alekm" wrote in message ... > I've got form X and TabControl T on it. ...
    (microsoft.public.access.gettingstarted)
  • Re: System.NotSupportedException
    ... Is it simply the addition of the Textbox without referencing anything else ... full framework that's not supported in the CF. ... > now and suddenly run into a problem that when I add a Control to a Form, ...
    (microsoft.public.dotnet.languages.csharp)