Ok, I made a form, 'frmSearchContact', and need it to open on a double-click event from a "main form", 'frmTask', when the user double-clicks on a listbox (list85) for "Pick-up Contact". I tried to use the 'call' procedure in the code for the double-click event like I did with a calendar form, 'frmCalendar' but it didn't work.

Suggestions?

Yikes, I would not use a double-click event, perhaps a button to open the form. But on the Double Click event of the list box, just use the DoCmd.OpenForm. If you used a button below the list box, then the wizard would do all this for you, including writing the linking code.

Did that help?

mmcdonal

I was just trying to keep the layout of the form a little nicer than cluttered. I wish we could upload to here cause then it'd be much easier to show what I'm trying to do cause there is a few things I can't figure out.

Can you show us the double-click code?

MMcDonal is correct in that double-clicking a list off a combo or list box is not a standard Windows action. Usually, there is an OK or GO or some button next to a list. You pick, then click the button to proceed. Because it's not standard, most people will not intuitively know you can double click it and make it do something.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

I got it to double-click. Now I just have to make the 'search for contact' form work, then allow the user to double-click the selected contact and have it insert it back, AND click the 'insert contact' and insert it back.

Do you need help on any of those functions? Or are you done?

mmcdonal

I figured it out, thanks.