Correct Code for Field Value

[Mel Henderson]

I found the following code in a previous Access Forum question.
How to make the value of a field carry over to the same field when you go to a new record and repeat for each new record untill the the user inputs a new value. (Pick Tkt Number is the name of my field).

When I try to compile the code I get an error and it wont compile. Cant seem to figure out what I have wrong, Thanks for any help I could get to fix this problem


Private Sub Form_Current()
If IsNull(Me.[Pick Tkt Number]) Then
Me.RecordsetClone.Bookmark=Me.RecordSet.Bookmark
Me.RecordsetClone.MovePrevious
me.[Pick Tkt Number]=Me.RecordSetClone.[Pick Tkt Number]

End If

End Sub

[This message has been edited by Mel Henderson (edited 04-04-2000).]

 

[R. Hicks]

For another approach to this go to the location below for more information.

http://support.microsoft.com/support/kb/articles/q136/1/27.asp?LNG=ENG&SA=ALLKB&FR=0

Good Luck,
RDH