Combo Box for two different fields

[Mojo1]

I want to create a combo box that will contain the Department and Department_Num in it. I have a table that has Department and Department_Num in it where I will draw the data from. I want to be able to have the values from the drop down go into each independent field when a new record is added.

Can some one help me with this one?

 

[Mojo1]

Here is what I have.

dbo_INV_INFSVC Table, which has a field Department and a field Dept_Num.

Only One Table!

 

[Dugantrain]

Alright, then, you will have to write a query that will capture these two fields off of this table and then base your record source for the combo off of this query. In the query, you need to change its Properties to "Unique Values"->Yes so that you'll only see each record once in the combo. I'm telling you, though, splitting this up into two tables is the way to go; what if you need to add a new department or delete a department from your current list?

 

[Mojo1]

I have attached an error I get when I try to select a Department from the combo box.I got this before and corrected it, but this time I have duplicated everything and can not understand why I am getting it.

I have checked field length, I have made sure the columns are represented correctly with the After Update Event code.
Any Ideas?

Bill

 

[Powerdog]

Hi Dugan
The way you showed the code:
"Private Sub Your_ComboBox_AfterUpdate()
Me.Your_Text1=Me.Your_ComboBox.Column(1)
me.Your_Text2=Me.Your_ComboBox.Column(2)
End Sub"
made it so easy to understand... I was wondering if you could show how to populate other areas from that same combo box... thats not included in the combo... but contains information about the subject...
meaning... I use the Combo box to lookup a name and it populates text1 and text2 (like above)... how do you get it to populate other text boxes that were not in the combo, but a part of the desired info... say that persons "city" ( to keep it elementary for me) to show up in the city box.

 

[Powerdog]

I figured it out... kinda easy once you figure it out