Hi - I can't seem to find the answer to this on the forum, I'm trying to set the default of one table's field to the entry of another table's field. ie: CoYearID (default value within the general tab) "tbl_companyyear-current.setcoyear" in a table called tbl_credits but I keep getting "Error type mismatch in the default value" from access 2000.
I want to be able to set the value in tbl_companyyear-current at the beginning of the year and I want my other tables to automatically have this value for each record. Then I can close the year and select the new year. Hope that makes sense. I can't seem to be able to get the info in the field. I really don't want to have to include this into each query etc.
Thanks in advance.
I want to be able to set the value in tbl_companyyear-current at the beginning of the year and I want my other tables to automatically have this value for each record. Then I can close the year and select the new year. Hope that makes sense. I can't seem to be able to get the info in the field. I really don't want to have to include this into each query etc.
Thanks in advance.
