Hi
Is it possible (and if it is possible: how?) to auto-fill (in the example below) field E with the data of field D when I create a new record?
Hi Domenic,
I remember that I used a long time ago some short-key combination with Shift or Alt, but I forgot how it worked, and I can't find it anymore.
In general I work in this way:
- make a clone of the form's Recordset: Set clone_set = Me.RecordsetClone
- Synchronize the sets: clone_set.Bookmark = Me.Recordset.Bookmark
- step back one record: clone_set.MovePrevious
- get the value of the field and assign: Me.ActiveControl = clone_set(Fieldname)
- close the set: clone_set.Close
Most important is you get the idea.
You can wrap this in a Sub that is triggered by a clicking a command button. It is also possible to couple this to a short-key, but that is more complicated.
Imb.