Search results

Small issue... Problem with setting the ControlSource Property is that if you want to change from the default location, you can't select an alternative from the combo list. However, if you set the Default Value property of cboLocation to '=[cboCurrentUser].[Column](3)' it now works. Thx

Thanks Bob, I wast just fiddling around with it and I came to a very similar conclusion. I used a Macro in the OnUpdate event for cboUsers to set the value property of cboLocation to '=[cboCurrentUser].[Column](3)'. Great to get such a quick and useful response!:)

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...

Hello, I am from Ireland and I work in laboratory medicine. I started using MS Access around in late 1992 with MSAccess 1.0! While I regularly use Access, I haven't done that much programming in recent years due to other commitments, but my New Years Resolution was to get going again as I have a...