Populating Cmbo Box

[JPearson]

I am about to go bonkers on this one. I have a form with 3 combo boxes.
It is set up so the 1st is auto populated with the departements. second(Jobs) has none, and 3rd has employee names. I have no issues getting the drill down to work from select dept and it populates correct Jobs, select the Job and it repopulates the employee name with the filtered list.
Since the EE list is populated on load I would like to select the employee name and auto populate the correct data in the department and Job.

The employee name box is driven by a 4 column query that produces
ID Name Dept Job

I can get the Dept to populate using the code below but the Job always comes back Null.

Help?

Private Sub cboEEName_Change()
    
    
      
'Populates Dept value correctly       
         Me.cboDept.Value = Me.cboEEName.Column(2, Me.cboEEName.ListIndex)
         
'Does not populate.......
         Me.cboJob.Value = Me.cboEEName.Column(3, Me.cboEEName.ListIndex)

    
End Sub

Thanks
-JP

 

[vbaInet]

Change the event to After_Update and use NZ()

 

[pbaldy]

Make sure the column count property of the name combo is 4.

 

[JPearson]

Thanks. It was the column count property that was set wrong.

Now that I have changed that I see the EEname, Dept, and Job all in the EEName cbo. How can I still pull that data yet only display the Employee name in the EEName cbo?

 

[vbaInet]

Set the Column Width of those corresponding fields to zero (0).

 

[JPearson]

Nevermind on the display. I figured that out.

Much Thanks on the count. Never even occured to me that it was being limited there.

Thanks again!
-JP

 

[pbaldy]

Much Thanks on the count. Never even occured to me that it was being limited there.

No problemo; it didn't occur to me either until it happened to me and I beat my head against the wall for way too long before figuring out this was the problem.

 

[JPearson]

Heh. I understand.. I was almost to that point myself!!!!