Reference a field on a form if it's open

  • Thread starter Thread starter Liz C
  • Start date Start date
L

Liz C

Hi!

I have a field on a report that gets a date from a form. It currently has
=[Forms]![DateF]![AcctPer] in the property on the report.

I would like to have it display that field if that form is open or another
field on a different form if the other form is open.

Any ideas?

Thanks a bunch!

Liz
 
You'd have to write a function that determines which of the two forms is
open and returns the appropriate value and use the function, rather than a
reference to the form field.
 
Back
Top