Hi All,
I have two tables, [Users] with a PK of [User ID] and [Locations] with a PK of [Location ID]. The [Users] table has a FK of [Default Location ID].
I have a form with two combo boxes [cboUser] and [cboLocation] whose row sources are the two tables. When I select a User in [cboUser], I...