Hi
I have a form (voucherchk) that has a one-to-one
relationship between two forms (cpvoucher & fpvoucher).
Each of the cpvoucher and fpvoucher forms have a cmd
button that opens a filter voucherchk so that each of the
cpvoucher and the fpvoucher forms have one specific
voucherchk form. What I want is to have a textbox that
shows either the cpvoucher or the fpvoucher date. I have
the following in the Control Source of that textbox.

=(Nz([cp vouchers].Form!vosubdate,0) Or Nz([fp
vouchers].Form!vosubdate,0))

For some reason this does not work. I thank you in
advance for any help you could provide. Thanks
Eric

You need to determine when you will display the cpvoucher value, and when
you'll display the fpvoucher value. You then can use an IIf expression to
select which one to display:

=IIf(ConditionForDisplayingcpvoucher = True, Nz([cp
vouchers].Form!vosubdate,0), Nz([fp
vouchers].Form!vosubdate,0))
--
Ken Snell
<MS ACCESS MVP>

"Eric" <(E-Mail Removed)> wrote in message
news:428a01c37658$9748dc00$(E-Mail Removed)...
> Hi
> I have a form (voucherchk) that has a one-to-one
> relationship between two forms (cpvoucher & fpvoucher).
> Each of the cpvoucher and fpvoucher forms have a cmd
> button that opens a filter voucherchk so that each of the
> cpvoucher and the fpvoucher forms have one specific
> voucherchk form. What I want is to have a textbox that
> shows either the cpvoucher or the fpvoucher date. I have
> the following in the Control Source of that textbox.
>
> =(Nz([cp vouchers].Form!vosubdate,0) Or Nz([fp
> vouchers].Form!vosubdate,0))
>
> For some reason this does not work. I thank you in
> advance for any help you could provide. Thanks
> Eric