That's what I have tried.
I have added to the 'after update' event in the ascension number field and this is how it shows:-
=[Due Date]=DateAdd([d],[Loan_type],[Loan_date])
I currently get this error message:-
The expression after update you entered as the event property seting...
This problem has become the bain of my life, I just cant find a way to resolve it - it should be so bloody simple.
Basically what should happen is; the user inputs the library book ascension number which returns all the data of the book included the amount time the book is allowed to be...
Cheers Bob,
Thats makes sense, but I still cant get the fucking thing to work. I assume its something I am doing/not doing - its driving me nuts.
I recorded the expression as due_date = dateAdd([d], [loantype],[loandate]
Help!!
I'm currently trying to build a library type DB as part of a college course. The part I cant get to work I thought would be fairly simple, but whatever I try doesnt work.
Anyhow I have field named(loan date) which is preset as todays date and then another field which holds the amount of time...