here are a couple of ideas (may not be the best)...
1.) you could hide an unbound field on your form and update it every time the value you want as default is updated. Then set the default value for the field to:
=nz(me.txtHiddenFieldName,"")
When a new record is created it will put whatever is in the hidden text box in the field you want as a default. (The Nz function puts an empty string, the way I have it set up, if the hidden field is null. You can make it put anything you want if the hidden field is null. You may also want to populate the hidden field when the form is opened. I'll leave that alone for now.
or another way...
2.) You would need to establish what the last value entered is to do this one. For example, if it is the very last value that anyone has entered, they you may want to store the time for that value and use Dlookup function, where part of your criteria is the last time
[This message has been edited by DML (edited 07-11-2000).]
