Search results

Great success with the Me.Control2 = M.Control1 and Me.Control1.OldValue advice - thanks a lot! Couldn't get the gblnCancel thing to work but managed to do what I wanted by making a box visible when Field.After_Update and then stating to cancel the After_Update event whenever the box is visible...

Thanks for the advice Pat. This sounds interesting and I'm going to try it right now.....

Thanks JC. Really sorry to come back again but I feel that we're close! I'm obviously going wrong somewhere.... I've inserted the code in the After Update property as follows: Private Sub LastName_AfterUpdate() Dim gblnCancel As Boolean If gblnCancel = True Then DoCmd.CancelEvent ' Attached...

Pat and JC - thanks. JC - I'm sorry - brain of an amoeba - how do I do what your suggesting? I've looked up 'gblnCancel' in Help but there is nothing about it. Your patience is appreciated guys!

Wow! That was speedy! - I have tried as you suggested but as the procedure requests a 'Goto Control' I get a message that tells me that I must save the field before the 'Goto control' can be acrried out.. This is my code - it basically copies and pastes important data into a text box...

I have an event procedure attached to the After Update of the 'Surname' field in a form. I also have a macro that, amongst other things, deletes the data in the 'Surname' field but of course as soon as the focus leaves the field, the After Update event procedure runs and prevents the macro from...

Many thanks for your reply - I appreciate that. Unfortunately I don't know diddley about converting to code but I guess I'll have to start learninig!!

I have a macro which opens a qery in Datasheet view, selects the first record, copies it then pastes it into an unbound text box in a form. Then another macro runs instructing it to go to the next record in the query, copy and paste it into the same form, after the first record, inserting a...