Hi to all
I have a form to insert some data to orders table , i use default value for OrderDate field , another table tblDefaultDate designed special to store one record only contains a field of date datatype to use it as default value for orders orderdate default value .
but when i change the value of DfltDate on tblDefaultDate while OrdersFrm ( that is based on Orders table) is opened , then when go to new record the default date do not takes the new value.
Q : how to update the default value for a control on the form based on another field on another table ?
I have a form to insert some data to orders table , i use default value for OrderDate field , another table tblDefaultDate designed special to store one record only contains a field of date datatype to use it as default value for orders orderdate default value .
but when i change the value of DfltDate on tblDefaultDate while OrdersFrm ( that is based on Orders table) is opened , then when go to new record the default date do not takes the new value.
Q : how to update the default value for a control on the form based on another field on another table ?