Hiding "field B" from layout if "field A" is empty
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?