Using List box to update a query

[sush]

Hi,

I have a form which is used to search stock records, The results are then presented in a List box. From this list box i would like the user to be able to select a particular record and click a button (or double click the record)and update another Query (Table)which is gathering information for the order (detail Lines)

The application is to collect orders.

Can any body help.?

 

[Jack Cowley]

Search help for ItemsSelected collection. There is an example there on how to determine which item(s) has been selected in the list box. Use this code in your Command button to find you which item was selected and then run your update query or whatever it is that you need to do.