alternative to me.refresh 1

[bookouri]

I have a subform where I put a value into a text box, I have an on-change event for that box that causes the box to do a simple calculation on another text box.

private sub text1_change()
me.refresh
me!sum_cost = me!quantity_pulled * me!cost_per_item
me.refresh
end sub

if I leave the refreshes in the sum_cost is updated appropriately, however the quantity_pulled box does some funky business with the select cursor... it will only allow single characters to be entered...unless you click off of the select cursor... anyway... the cursor works fine if I leave out the me.refresh statements.. but the quantity_pulled is not displayed.. is there an alternative to refresh? I tried requery but it did something totally different...

thanks for any suggestions

 

[JeremyNYC]

Use the afterUpdate event instead of the change event. Then you can get rid of the me.refresh lines.

Also, you'll probably want to do the same calculation in the Current event of the form, so that that text box has the appropriate value in it when you open the form and when you move from record to record.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[bookouri]

Thanks, that fixed it!