I have a main form named Categories and I use a subform for my products for that category. If user updates the Inventory then I need to requery main form so warning Inventory Levels can show up. Right now I use 2 unbound textboxes to refer to the subform for their values, this works.
The warning works as well if the inventory has become too low. But only if I go to the next record and come back or close and reopen the form.
I need a way to requery my main form. I tried the after update event for the unbound controls that uses the subform as its control source, that did not work.
Subform name is AddorDeleteProducts
Thanks in Advance,