I have a table that stores mailing list contacts. I have a listbox that lists all the last names in the table (from a query).

1- I would like to be able to double click on a name in the listbox and open that record in my contact form to be edited. Everytime I double click on a name, the form, opens but on the first record; not on the name selected.

2- Instead of just the last name populating in the listbox, I would like the format (last, first).

I know these are probably very simple issues but I'm not having any luck trying to solve them. If anyone can point me in the right direction, I would greatly appreciate it.

Thanks,
Nick

1 - You can run a query to select the record you want to edit but using defining criteria like: SELECT * FROM Table1 WHERE Field1='defining criteria';
Your defining criteria can be your primary key or something that will set the record in question apart.

2 - The query that makes the list needs to look like this: SELECT Table1.Last & ', ' & Table1.First AS Name FROM Table1;

Hope this helps.

Kenny Alligood

1) On the listbox's Double Click event put something like:
where the criteria expression is any valid criteria, e.g. "[Name] = '" & Me.txtName & "'"

2) In the listbox's properties, set the Column Count property to 2, set the Column widths to e.g. 2";2" (two inches each), set the list width to the sum of the columns (in this case 4"), and set the Bound Column to 1 or 2 depending on which field you want to use in your calculations/operations.

On your listbox's recordsource property, make sure you're selecting the two fields in question. They'll both show up on your list but only the bound one will affect anything.

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