I'm attempting to do the following and am having no real luck doing it. I am setting up a small contact management database and want all my contacts to be classified as contact types. Each individual contact can be more than one contact type.

So what I have right now is a field in my contact table called contacttypeid. There is another table called contacttype that houses each contact type referenced by contacttypeid. I have also established a relationship between the two contacttypeid fields. What I am trying to do on the initial form (where general contact info is entered) is populate a contact type listbox that allows the user to select multiple contact types.

I am trying to have the list box be populated by the values in the contacttype table and I want the results stored in the contacttypeid field in the main contact table.

Currently, I have my listbox name as contacttypeid, the control source is contacttypeid. The row source type is set to table/query, and the row source is currently a sql statement:

SELECT [Contacttypes].[Contacttype] FROM [Contacttypes] ORDER BY [Contacttypes].[Contacttype];

which gives me no data returned in my listbox.

Any suggestions as to what I'm missing?

Thanks,
John Coutts

John - I suspect that your approach may make it difficult to do anything with the field when you populate it.

I would have a series of Check Boxes on your form which are bound to Yes/No fields in the contact table. This is simple for the user and easier for you for queries etc.

Hope this helps .... Peter