I'm trying to auto populate a field in Access depending on if a combobox is populated and if not then pull from another combobox but i cant get it to pull from the the second comboxbox
The information if is someone is currently working at a higher role than normal. So i have acting Role, Normal Role and current role
Thanks in advance
Current code is
If ActingRole = Null then CurrentRole = NormalRole Else CurrentRole = ActingRole End if
If pulls from Acting Role but does not pull normal role even in acting role is empty
