Refference Unbound Text Box

H

hmiller

I have an unbound text box on a form. The text box has a controll
source as follows:

=IIf(DateDiff("d",[DateSent],[DateReceived])<=5,"On
Time",IIf(DateDiff("d",[DateSent],[DateReceived])>5,"Overdue","Not
Submitted"))

I have named the TextBox "PPSub".

My question is; can I now refference this text box in another unbound
text box somthing like this

=Dcount("*","frmPPTrax","PPSub='On Time'")

The frmPPTrax is the name of the form where said unbound text box
"PPSub" is located.

I just don't want to have to create a Dcount with that IIF statement in
it.

Thanks Everyone

Hope this was clear...
 
T

Tom Ogilvy

Dcount wouldn't even work with those arguments - it is totally based on
values in cells.

Textboxes can be bound to cells or filled with code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I refference then search text in a worksheet text box 1
Access 2 Digit year in Access Text Box 3
date diff using criteria 3
auto populate text box based on combo box value 1
Iff problem 3
Option group value in an unbound text box. 5
unbound text box 1
expression in form 4

Top