AutoFillNewRecordFields

  • Thread starter Thread starter James
  • Start date Start date
J

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
 
James said:
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
Click to expand...

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.
 
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
 
Back
Top