Creating a new form

C

cadman

ALL,

I am trying to create a combo box that will gather the data from three other
boxes. I have been able to get the data to show up in the drop down box but
it will not stay in the area when it is selected.

This is what I have done so far. I have been going through the wizard to
create the combo box, first I select that I want the box to get the values
from a table or query, I then select the table and the fields that I want.
Then I sort the fields in the order that I want, then I select the field that
I want the data to show up in. I then select the same field for where I want
the data stored, and then label the title of the new combo box.

Is there something else that I have missed or am I not doing something
correct. I would like to eventually set up filters based on conditions for
each of the columns.

I would appreciate any advice (HELP) on the situation.

Thanks
 
L

Linq Adams via AccessMonster.com

If what you're saying is that, after making a selectiom, only one field shows
in the combobox, this is the normal behavior. You can assign the other values
of the selection, in the AfterUpdate event, like this:

Private Sub YourComboBox_AfterUpdate()
Me.Company= Me.YourComboBox.Column(0)
Me.Address = Me.YourComboBox.Column(1)
Me.City = Me.YourComboBox.Column(2)
Me.State = Me.YourComboBox.Column(3)
End Sub

With the first, leftmost field in the combobox being Column(0), the next one
being Column(1) and so forth.
 
C

cadman

I have tried to set up the AfterUpdate as you have said, but I still am only
seeing 1 set of numbers on the drop down box.
I'm not sure if this matters or not but I forgot to tell you that I have an
input mask created in the table field that this data will be going into.
Would this be the reason also why I am unable to see the remainder of the
numbers.
 
Top