is anybody aware of how to use a list box column as a criteria in a query?
basically i have a list box based on a query, and the 2nd coloumn (column(1)) i want to use as a criteria....this is so i can update a value in another un-opened table. i have tried the following [forms]![frmOrderData]![lstExtensions.column(1)] but i get invalid use of brackets....so i try [forms]![frmorderdata]![lstextensions].[column(1)] and it doesnt reference it....any help would be appreciated