Trouble with AutoFillRecords

[**Natasha**]

I have a module to autofill records to match the previous
records. The problem is that it fill all fields and I need
just one field. Also, I end up with alot of duplicates
because when I enter one record, a new record comes up
automatically filled with info. Please help!!!

 

[Reid]

Here's a Microsoft article that can be easily adapted for a single field:
http://support.microsoft.com/default.aspx?scid=kb;en-us;210236&Product=acc2000

Here's something from The Access Web:
http://www.mvps.org/access/forms/frm0012.htm
This uses a control's DefaultValue property and is probably the easiest.