Affected row with Datasheet View (1 Viewer)

L4serK!LL

Registered User.
Local time
Today, 22:55
Joined
Jul 22, 2002
Messages
59
I got a form (datasheet view) with all orders for one day, with a column which represents the delivered number...

Example:
Headlights, 10 ordered, 0 received

User changes the received field:
Headlights, 10 ordered, 4 received

What I would like to see happening is as follows:
The old line is removed, and instead of that 2 lines are added:
Headlights, 4 ordered, 4 received, Date()
Headlights, 6 ordered, 0 received

Now, for that I need to detect that when the form is altered, what line is altered so I can remove it and put the others in it's place...
I have absolutely no clue how to accomplish this (probably because it's monday morning here :rolleyes: that should teach me not to behave like I do during the weekend :p )
 

L4serK!LL

Registered User.
Local time
Today, 22:55
Joined
Jul 22, 2002
Messages
59
Wooohoooooo, I'm G000D :p
Solved it by cloning the Me.Recordset and adding a record there based on the .LastModified :)

Thanks all 4 the support ;)
 
Last edited:

Users who are viewing this thread

Top Bottom