Date Diff Problem

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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))
 
Back
Top