I have a TabStrip control with 2 tabs. The first tab (circulation) has a ListView showing all the movies in the database. The second tab (details) is suppossed to display the details of the movie. I want to code it in such away that as long as a movie is highligted in the ListView, when you click on the details tab, the details of the movie that was highlighted is shown. The same effect should be seen if I double click on a selected movie in the ListView. How can I code thatt?

For the first part, AfterUpdate of the list view, set all of the controls on the Details page. The controls are present for being filled in even when they are not visible. Then when the Details tab is selected, the already-updated controls will be presented.

For the double-click, in the event procedure do the same updating process, then set the Details tab as the active one.

Does that help?

Do I need to change the SELECT code to have a WHERE clause that refers to the selected item in the listView? If yes, how can I reference the selected item in a ListView. Currently, the listview is filled with records from the recordset and what is remaining is just to ensure that the details of a selected item are presented in the controls in the second tab.

Thanks

Loop through the .items of the listview, and when you find the one where .selected = True, store the value in a variable.

Following that, as you build your SQL, in your WHERE clause, concatenate the value of that variable.