ListBox in SubForm

T

tomrector

Thanks before i even begin... been working this one for a while.

I have a ListBox in a sub form that I have to "Click" on th get it to
pass data.

TextBox= PartUsed1
Control is Query Table ItemDesc and ItemSell from Parts table
* requeries Text64 AfterUpdate

ListBox= Text64
Control is
SELECT Parts.ItemSell, Parts.ID FROM Parts WHERE
(((Parts.ItemDesc)=Forms!Vehicle!Work.form.PartsUsed1));
* requeries PartsSell1 afterUpdate

TextBox=PartsSell1
control is Text64

My problem is that PartSell1 won't update until I 'click' in Text64
(text64 does update by requery)

AnyIdeas on how to have an automatic 'click in listBox Text64


Thanlks again,
Tom
 
Top