Here is a problem for the old sages...I have a vb6 app that I am upgrading. It has a list box with a list of data of varying number. It is basically a list of participants in a race with their first name, last name, gender, etc. What I want to do is be able to double-click on that list and have the data edit form come up as a modal form with that person's data populating the fields on that form.
Currently you have to open the edit form, find their unique ID in a drop down and click on that to get their data to populate. I want to make the process quicker and easier.
Thanks a ton. Best site ever for helping hacks like me...
1) How to get the frmEditData to open when double clicking an item in the list of the frmPartic form, and
2) How to pass the unique id of the record that was selected via double-click on the frmPartic form to the frmEditData form so that it can populate the necessary fields.
Sorry I was not more complete initially.