I am working on cash book / Day Book Project.
I am stuck with a problem that am unable to solve. I have tried to locate the issue but am unable to do so.
I have placed a default value of Date on the date field DBDATE on Form "DBKViewSubfrm"
When I do the data entry on the form "DBKViewSubfrm" and skip to enter the value of date in DBDATE as it should take the system date due to the default date value is set to date()
after the transaction is completed the date is changed to previous date value.
I have attached a sample database for better understanding the problem.
Help will be appreciated.
Please Download Sample
Test Sample.zip