Listbox selection to open record

Hi guys thought i'd give some feedback on your excellent work, all suggestions worked fine, but I have now revamped the database and have the main form a continuous form, the listbox double click works fine, but doesn't go the record on the form and the main form remains open, also the combo search isnt working either, sorry guys can you help at all.
 
i have a list box called "SearchResults" which has 2 columns Account and Name and a text box which filters the list,

i would like to be able to double click the list box item to open the detailed form "1CustomerDetails" using the account. :banghead:

could anyone post the code on here

(i'm trying to learn how to do this but I've only just started)
 
Hi Dan, when you double click are you going to opening a single form?
 
Hi guys thought i'd give some feedback on your excellent work, all suggestions worked fine, but I have now revamped the database and have the main form a continuous form, the listbox double click works fine, but doesn't go the record on the form and the main form remains open, also the combo search isnt working either, sorry guys can you help at all.

Sorry, but I have been knee-deep in my own projects.

Can you explain in simple English what you want to happen when the user double clicks an entry in the main form list box?

Example:
1) User double clicks in list box containing account numbers
2) Customer form opens with the current record matching the selected account number
3) main form closes
 

Users who are viewing this thread

Back
Top Bottom