I have an unbound text box that is filled with the results of a query. The fields in the textbox are
ItemID and ItemType
I would like to be able to click on any of the results and have it update a hidden text box on the same form so that I can use that result to filter a second subform. The later part of the quetstion has been answered here:
The first part seems like it would be simple, but it is tough for me. When I click on an item in the textbox results of a query I would like the ItemID to be updated into the hidden textbox. something like:
me.textbox.Itemid = me.hiddentextbox
Is this possible??