listbox duplicates and opening forms to new records

[nkrukovsky]

I have two small (I hope) questions.

1- I have a listbox that lists client names. The listbox values are generated by a query. If you click on a client name, it generates an activity report for that client. If there are 'x' entries per client in the table, the client's name appears 'x' times in the listbox. How can I eliminate the duplicates in the listbox?

2- I have a command button that opens a form for contacts/mailing list. I would like the form to open on a new record and ready to input data. It currently opens on the first record by default. How can I resolve this?

Sorry if these questions are basic. I am quite new to VBA and can't find the answer to these issues. Any help would be appreciated.

Thanks,
Nick

 

[MisterC]

1. Use a SELECT DISTINCT (group by) query for your listbox source.
2. Change the Form's DATA ENTRY Property to "YES"

 

[nkrukovsky]

GREAT! Thank you very much!

 

[nkrukovsky]

Or...
DoCmd.OpenForm "frmContactsLookup", acNormal, "", "", acAdd, acNormal