S
SillySally
Hi. I have a combo box ComboSO and a field Spouse. If
ComboSO has a value in it, I want Spouse to reflect that
same value.
If ComboSO is blank, I want Spouse to be blank until the
user populates (or not) the Spouse field.
The code that I'm using opens a new record with Spouse
field as #Name?
Private Sub ComboSO_AfterUpdate()
Me!Spouse = Me!ComboSO.Column(1)
End Sub
I tried using default value, but that didn't work with
Column(1). The AfterUpdate gives some of the
functionality that I need and I flailed trying different
bits of code. Any suggestions? Thanks!
ComboSO has a value in it, I want Spouse to reflect that
same value.
If ComboSO is blank, I want Spouse to be blank until the
user populates (or not) the Spouse field.
The code that I'm using opens a new record with Spouse
field as #Name?
Private Sub ComboSO_AfterUpdate()
Me!Spouse = Me!ComboSO.Column(1)
End Sub
I tried using default value, but that didn't work with
Column(1). The AfterUpdate gives some of the
functionality that I need and I flailed trying different
bits of code. Any suggestions? Thanks!