AutoFillNewRecordFields

[James]

I want Access to automatically enter a value entered in
one particular field from the previous record into the new
record.
I have found this AutoFillNewRecordFields hidden text box
solution, but it seems not to work on the database I have
set up

 

[Rick Brandt]

I want Access to automatically enter a value entered in
one particular field from the previous record into the new
record.
I have found this AutoFillNewRecordFields hidden text box
solution, but it seems not to work on the database I have
set up

Are you using a continuous or datasheet form? Dynamically assigning
default value properties will generally not work on those as the "New Row"
is assigned its default properties the moment it is created. This would
usually be before you've run your code to change it.

 

[Guest]

Build a current event code sub routine.
In that test for me.newrecord. If true then
Clone the recordset and within the clone navigate to the
prior record. Now you can grab the data you want and post
it to the new record.
See help file for: RecordsetClone