Updatinga textbox/fieldl list based on a query

[velcrowe]

I have a textbox that is set equal to countitem field of a query. The query is based on a subform that exists on the same form. I am trying to update the textbox every time the number goes up or down on the query. Whenever I open my form the number for this textbox is updated. Can I update this field without having to open the form everytime?

 

[FoFa]

Depends on how it is setup. You may just need to requery that text box when an update is required.