Need Help on a cascading combobox

[pikoy]

What am I missing? I get both 1 and 2 to work. However, the 3rd combo with the red rowsource does not give me values.


1st RowSource: SELECT T_En.En, T_En.ID FROM T_En;

1st AfterUpdate:
Private Sub Hos_AfterUpdate()
Me.U1.Requery
End Sub
--------------------------------------------------------------------
2nd RowSource: SELECT T_U1.U1 FROM T_U1 WHERE (((T_U1.ID)=Forms!F_Incident!Hos)) ORDER BY [U1];

2nd AfterUpdate:
Private Sub U1_AfterUpdate()
Me.SN.Requery
End Sub
---------------------------------------------------------------------
3rd RowSource: SELECT T_Staff.ID, T_Staff.[LastName] & " " & T_Staff.[FirstName] AS Expr1 FROM T_Staff WHERE (((T_Staff.ID)=Forms!F_Incident!U1)) ORDER BY [LastName];

 

[JHB]

What am I missing? I get both 1 and 2 to work. However, the 3rd combo with the red rowsource does not give me values.

It could be a couple of things:
Is the combobox's property set up right?
Check the Column Count, Column Width, Row Source Type etc.

Create a query to see if some T_Staff.ID is equal Forms!F_Incident!U1, (the form should be in "Form View"):

SELECT T_Staff.ID, T_Staff.[LastName] & " " & T_Staff.[FirstName] AS Expr1, Forms!F_Incident!U1 AS FormValue FROM T_Staff ORDER BY [LastName];

 

[pikoy]

It could be a couple of things:
Is the combobox's property set up right?
Check the Column Count, Column Width, Row Source Type etc.

Create a query to see if some T_Staff.ID is equal Forms!F_Incident!U1, (the form should be in "Form View"):

Thanks JHB.....

I saw what's wrong. It pays to get up, drink coffee and revisit items after a few minutes. :banghead: Merry Christmas!