Remember Last Numeric Value on a Form

[Thermalmonster]

Hi Folks

I have a form with a fields 1 to 15. I want Access to remember the last entry on each of the fields when a new record is created.

Im using this code



Private Sub Ctl1_AfterUpdate()
If Not IsNull(Me.Ctl1.Value) Then
Ctl1.DefaultValue =Me.Ctl1.Value
End If
End Sub





Getting compile error Ambiguous missmatch or somthing


Please Help
Thanks in advance

[pbaldy]

You don't have 2 subs that begin with:

Private Sub Ctl1_AfterUpdate()

do you?

[Thermalmonster]

Thanks Paddy
I dont think so im a bit new at this
the fields in the form are created from a table with fields 1 to 15
There are no duplicates

[Thermalmonster]

Oh it would appear that on clicking the text box in the previous form that it is called Ctl1 also dont know why
hmmm
so need to change the name of the othes

[Thermalmonster]

Now there are no Duplicates and still get same error

[pbaldy]

Can you post the db here?

[Thermalmonster]

Is there a tool for attaching files?

[pbaldy]

Yes, go into "Go Advanced" then "Manage attachments". Do a compact/repair and then zip which should make it small enough.

[Thermalmonster]

Ok
This is the foim trying to create
Im trto get all the Horizontal chainages be remembered in the nerecord
the Slope chainages are calcfrom the Horizontal
Calculatiois done in the Table

Thanks
Heaps

[Thermalmonster]

OK I have this working now, but when you re open the form it does not work untill you have repopulated the form again!!!
GRRRRRR
Any Ideas please anyone????