We have a unbound field, cbobase_kpi that is controlled by a query. Code:
Private Sub cboSub_Skillset_AfterUpdate()
Me.cboSubSkillset.Value = Me.cboSub_Skillset.Value
Dim var As String
var = "Select [KPI] from BaseKPI where [Sub-Skillset]='" & Me.cboSub_Skillset & "'"
Me.cboBase_KPI.RowSource = var
Me.cboBase_KPI.Selected(0) = True
We need to have our bound txt box, txtBaseKPI equal the value from cbobase_kpi.
We have tried after updates, on click, and on change events with the following code.
Me.txtBaseKPI.value = Me.cbobase_kpi.value OR
Me.txtBaseKPI = Me.cbobase_kpi
We have tried to relate it as a variable. We aren't getting any errors, just simply an empty null box.