Combo Box Options

[RikApple]

Hi,



I have a ComboBox on a form which has 3 different query results within the drop down as per the picture;


when the form data is submitted only the first field is shown which is fine, but I want the data in the 2nd and 3rd field to be saved in their respective table columns.

Is there a way of doing this? open to suggestions, if there is a better way of doing this, all I want is for the user to select from the list of "Live" Courses.

Many thanks in advance

Sarah xx

[Micron]

If you've got these field values in a combo or list box and they're not value list items (i.e. they come from a query or table) then that means you already have them it table fields. That begs the question as to why you want to store them again in another table or record? Methinks you have an underlying issue.
If none of that matters, you can refer to combo or list box columns by their column number property. Me.myListbox.Column(0) would refer to the 1st column as the collection is zero based.

If what I said might matter, maybe you should post a pic of your relationships window if you have created relationships.