two cboboxes

J

Junior

Using two unbound cbo boxes and an unbound txtbox
i want cboTwo's available selections to be based on cboOne selection
i set txtTmpPos = cboOne in afterUpdate
cboOne works properly and txtTmpPos changes properly when a new value is
selected in cboOne
however, cboTwo does not display the proper selections, when i change the
selection in cboOne
what am i doing wrong?
tlkpType.pos and txtTmpPos are both strings
Thanks

cboOne

SELECT [TlkpSpec].[SpecID], [TlkpSpec].[Specialty] FROM TlkpSpec ORDER BY
[TlkpSpec].[PrintOrder];



cboTwo

SELECT [TlkpType].[TypeID], [TlkpType].[Type] FROM TlkpType WHERE
[tlkpType].[pos] = txtTmpPos ORDER BY [TlkpType].[Order];
 
Top