List Box Copy Record

[end922]

Greetings,

little problem. Have a list box made from a table of addresses. Throug the process the user will be prompted to double click on an address they want to add to the shipping manafest. I want that address they double clicked on to be copied to a table using an append query. I have the query built but do not know how to write the query criteria. The name of the list box is "ListAddress" with in the address form.

Thanks
E

 

[Remou]

You can refer to a list box that allows only a single selection in a query. Let us assume that you have included AddressID as the bound column:

[tt]SELECT * FROM AddressesTable WHERE AddressID = Forms!AddressesForm!ListAddress[/tt]