Stumpped again...

[JediYodaNT]

Hello everyone.
YOu guys have been a great help so far in getting my database up and running for my department. I've been able to get most all of my main Entries form completed and behaving as desired....with one exception.

So, I've created a functioning link between the Function combo and the Process combo. When an assocaite uses the pulldown list to chose a specific Function, the Process combo is then populated with the corresponding processes handled by that Function. From an entry standpoint, this is working great. The hiccup occurs when you go to look at the actual data saved to the primary "Entries" table. Instead of saving the proper Function name, the ID number for that function is stored. I've tried changing the bound column from "1" to "2", but in doing that, the event breaks and fails to populate the Process combo. Would you guys mind taking a look at this and seeing what I might be able to do to fix this?

Private Sub FunctionCombo_AfterUpdate()
' Update the row source of the ProcessCombo combo box
' when the user makes a selection in the FunctionCombo
' combo box.
Me.ProcessCombo.RowSource = "SELECT Process FROM" & _
" T_Process WHERE Function = " & _
Me.FunctionCombo & _
" ORDER BY Process"

Me.ProcessCombo = Me.ProcessCombo.ItemData(0)
End Sub

 

[boblarson]

The ID SHOULD be the item stored in the table. You should NOT store the text. That violates normalization rules. You can get the name by use of a query.