enter code, display description & vice versa

[Scooterbug]

Here is the db back...with the changes. The bound column for the Description combo needed to be changed back to 1 as well.

 

[mitchem1]

Here is the db back...with the changes. The bound column for the Description combo needed to be changed back to 1 as well.

Sorry, I don't think I'm on the same page. And thanks for your patience. Using your original code, it is not possible to type in the ID or Desc combos? The drop down must be used in order for it to work?

 

[Scooterbug]

Sorry, I don't think I'm on the same page. And thanks for your patience. Using your original code, it is not possible to type in the ID or Desc combos? The drop down must be used in order for it to work?

Private Sub EquipmentCategoryDescription_AfterUpdate()
Me.EquipmentCategoryID = Me.EquipmentCategoryDescription
Me.EquipmentCategoryID.Requery
End Sub
 
 
Private Sub EquipmentCategoryID_AfterUpdate()
Me.EquipmentCategoryDescription = Me.EquipmentCategoryID
Me.EquipmentCategoryDescription.Requery
End Sub

That is the correct code...I promise I apoligize for the runaround.

 

[mitchem1]

This seems to be working great, but I want to make sure I've got all the settings correct on the combos. Is it correct that EquipmentCategoryID should be the Control Source for both and the Bound Column should be 1 for both? Also, the On Change event should be removed? Thanks again!

 

[Scooterbug]

Yup...that is correct. Sorry for the confusion