Once a list box has recovered its data from a query and has produced that list in a form, is there away of enabling a user to double click that reocrd to select it and go to that record on another form? (Using Access 2003)
Thanks for the prompt response. This wouldn't actually work, it came up an error stating that it was expecting an "=".
myListBox brings up information from a query from a master table. The information in that table is inputted from a form. I would like to be able to double click an entry in myListBox and goto the form view of that entry from that table. Is this possible?
Thanks for that example. If you had a form that inputted the data into the table that you created and then another form that brought that list box up. Could you double click that entry in the list box and make that take you to the other form and that particular entry ?
Sorry to be a pain - and thanks for your help so far !
This has generated an error 424 -Object Required. I'm not sure what i've done there. I created the Docmd line above in the event 'double-click' on the list box. I replaced the form name with my form name and used the table row identifier for the ID ("Unique Number" in my case) and used my List Box name in the right place - Any more ideas?