Reference a field on a form if it's open

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
 
D

Douglas J. Steele

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.
 

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

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access Access Report Works on One Machine but not Another 3
Reference controls on a dialogue form as the parameters 1
Conditional DB reports 3
Using Data from a Report in a Form 4
Adding Signature To Report By Way Of Selecting Image From My Computer 0
Changing a text field in a report to a Date/Time format 1
Moving data from a report to a form 4

Top