Listbox selection in a form
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?