retaining values

[Jeff_Ford]

i have some textboxes on my form that i want to retain the same values from record to record until changed, i have implemented Microsoft Knowledge Base Article - 210236, but all the values on my form retain their values record to record not just the ones i want (basecoat batch number and thinner batch number on the attached project), if somebody has the answer i would really appreciate it as its bugging the hell out of me!

 

[Jack Cowley]

Your hidden control "AutoFillNewRecordFields" has a problem with a couple of extra characters at the end of the name. If you open the property sheet for the control you will see that it says, "AutoFillNewRecordFields" in the blue line at the top of the property sheet and the word 'Fields' is followed by two boxes. Place the cursor at the end of the string "AutoFillNewRecordFields" in the Name property and hit the delete key twice. This should remove the two boxes and now your code should work.

Jack

 

[Jeff_Ford]

fantastic that got it. Cheers

 

[Jack Cowley]

You are welcome...

Jack