I have an Access database that contains 2 tables. The main input form is a master/child setup.
Within the subform are 4 fields which contain data that is infrequently changed. The users would
like to have the value in each of these fields set as a default value so that it repeats from one record
to the next, unless they then need to change the value. THEN, THAT NEW VALUE WOULD NEED
TO BE ASSIGNED AS THE DEFAULT VALUE UNTIL IT IS CHANGED AGAIN. AND THEN THE
DEFAULT VALUE WOULD BE THAT NEW VALUE ENTERED. I know this has to be done in VBA,
but I can't seem to come up with the correct code to make it work. I was trying to use a function to
accept the value passed in from the field, and then assigning that value as the new default value.
But again, I don't have the code written correctly. Is this the best way to solve this problem, or am I
going about it all wrong? |
