Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

updating form

Status
Not open for further replies.

sdimaggio

Technical User
Jan 23, 2002
138
US
How do you update a textbox on a form when the textbox is based on formula drawing from a combobox.

The formula I entered works, because when I save the form and then reopen the form all the values calculated in the form are correct.

What I want to happen is that when I select a record from a combo box the corressponding textbox's formula recalcs or requeries.

Thanks

steve
 
On the After Update event of the Combo Box, place the command Me.recalc which should cause the form to recalculate the other fields...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top