AnsweredAssumed Answered

Hiding "field B" from layout if "field A" is empty

Question asked by SarahJayneDavies on Apr 13, 2013
Latest reply on Apr 13, 2013 by philmodjunk

Title

Hiding "field B" from layout if "field A" is empty

Post


     Hi.

      

     I have a database setup to record invoices from one company that are outstanding, have been paid, etc. I have a "Paid" field with a drop down list with values from a yes/no value list, so that I can search for outstanding invoices etc.

     I than have a date field called "Date paid". Obviously, I am asked for a date, regardless of the value in "Paid". I have tried to change things so I am only asked for a date if the "Paid" value is yes.

     So far, I have had no success so wondered whether anybody here could help?

      

     Many thanks.

     Sarah

      

invoice_database.jpg

Outcomes