yes! That sounds very close. I would love to have you look at my data, but some of it is protected by the company. What parts would you like to look at?
@pbaldy: Yes I "tried" that, but I must have done something wrong as it did not work. Could you provide steps in more detail?
Is the code behind the combo putting the correct value in the textbox, and it's just not getting saved? If so, you just need to set the control source property of the textbox to the appropriate field in the table. It should be available in the dropdown.
will it allow me to select more than one field to save to?
As mentioned earlier, no. A control can only be bound to a single field. If you have more than one, you'll need more than one textbox.
So confused now, because I was able to "display" all the required info to multiple fields using a single drop-down using the info you provided. Now I just want to be able to save the data that it displays into a new record.
I assume when you displayed it you had multiple textboxes with:
=ComboName.Column(x)
Now you need a line in code for each one like:
Me.TextboxName = Me.ComboName.Column(x)
and change the control source of each textbox to be the field name instead of the formula. You would still have the single dropdown.
ok so I would enter that syntax for each of the text boxes, or in the 'after event' control of the combo box?
The after update event of the combo, which would then look like:
Me.FirstTextbox = Me.ComboName.Column(1)
Me.SecondTextbox = Me.ComboName.Column(2)
Me.ThirdTextbox = Me.ComboName.Column(3)
and that will save it too then right?
and how do you seperate each line? Is it by a ";"?
Nothing separates the lines. It will look exactly like I posted, with the names changed of course. They will all save as long as the textboxes have the appropriate fields as their control source.
I tried it just with one text field as a test...but nothing auto-populated. So to summarize: I changed the control source of the text box back to what it was called....then went to properties of the combo box, went to the event tab, and entered: me.site type=me.combo466.column(2), then saved. Clicked open new record on my form, selected a site from the drop down, but nothing populated the 'site type' field. Is there something else Im missing?
should the combo box remain unbound?