Before Update event not working as I expect (1 Viewer)

[Lateral]

Hi guys

I have a continuous form displaying a number of text boxes.

I have a text box called “txtNewPrice”.

I have some VBA code that I use to keep track of when the user manually changes the data in txtNewPrice via a module that is triggered by the “Before Update” event.

this all works perfectly when the user manually enters a value into the field. Both the old and new values are captured and written to the audit trail


I also have some VBA code attached to the double click event that performs a calculation and then updates the txtNewPrice field with the result.

The problem is that when the double click event is actioned, it appears that the “Before Update” event isn’t and I not getting the audit record written.

does anybody have an idea of how I can fix it?

cheers
Greg

 

[theDBguy]

Hi Greg. You could try to "call" the BeforeUpdate event in your DblClick event code.

 

[Lateral]

Hi Dbguy.
I think I tried that and it almost worked but it was not capturing the “before” value of the field.

 

[theDBguy]

Hi Dbguy.
I think I tried that and it almost worked but it was not capturing the “before” value of the field.

Oh, yeah, that would be true. I guess you could just add the same code you're using in the BeforeUpdate event in your DblClick event (with the exception of using the Old Value, of course). What does your DblClick event look like?

 

[Lateral]

It’s basically the code you helped me with in an earlier post

I can't seem to get this simple formula working when using a percentage field in the calculation

Hi guys I have a table that contains a list of Parts in a stock and inventory type of database. It has field called "[Markup]" that contains the percentage markup and is calculated and updated each time the database is start via a query. The [Markup] field is defined as a Percentage field...

www.access-programmers.co.uk

 

[MajP]

I also have some VBA code attached to the double click event that performs a calculation and then updates the txtNewPrice field with the result

I think this may be normal behavior since you are committing the value to the buffer. Try in in the double click, instead to set the text property of the control instead of the value property.