Default value

[Guest]

Hi. I have a combo box: ComboSO that is working well. Then I have a field
called Spouse (Name: Spouse, Control Source: Spouse). I have Spouse's
Default Value as =Nz([ComboSO].[Column(1)]," ")

The reason I've done this is I have a field for Member Spouse (ComboSO). If
ComboSo is populated, I want the same data to automatically fill Spouse. If
the Spouse is not also a member (ComboSO is null), but there is a Spouse, I
want to be able to manually enter the spouse's name in Spouse.

My set up works as intented. But. When I create a new record, Spouse
appears as #Name? so of course I've done something incorrectly. How can I
have the functionality I need with Spouse and ComboSO without Spouse being
automatically populated with #Name? at a new record? Thanks!

 

[Allan Murphy]

Stephanie

Remove your default value for Spouse and in the AFTER UPDATE event of
ComboSO put the following code

me!Spouse=me!ComboSo.Column(1)

 

[Douglas J. Steele]

Rather than trying to use a default value, put code in the combo box's
AfterUpdate event to populate the Spouse text box.

 

[Guest]

Thanks- that did the trick!

Rather than trying to use a default value, put code in the combo box's
AfterUpdate event to populate the Spouse text box.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi. I have a combo box: ComboSO that is working well. Then I have a
field
called Spouse (Name: Spouse, Control Source: Spouse). I have Spouse's
Default Value as =Nz([ComboSO].[Column(1)]," ")

The reason I've done this is I have a field for Member Spouse (ComboSO).
If
ComboSo is populated, I want the same data to automatically fill Spouse.
If
the Spouse is not also a member (ComboSO is null), but there is a Spouse,
I
want to be able to manually enter the spouse's name in Spouse.

My set up works as intented. But. When I create a new record, Spouse
appears as #Name? so of course I've done something incorrectly. How can
I
have the functionality I need with Spouse and ComboSO without Spouse being
automatically populated with #Name? at a new record? Thanks!

 

[Guest]

Thanks for the help- perfect!

Stephanie

Remove your default value for Spouse and in the AFTER UPDATE event of
ComboSO put the following code

me!Spouse=me!ComboSo.Column(1)

--
Allan Murphy
Email: (e-mail address removed)

Hi. I have a combo box: ComboSO that is working well. Then I have a field
called Spouse (Name: Spouse, Control Source: Spouse). I have Spouse's
Default Value as =Nz([ComboSO].[Column(1)]," ")

The reason I've done this is I have a field for Member Spouse (ComboSO). If
ComboSo is populated, I want the same data to automatically fill Spouse. If
the Spouse is not also a member (ComboSO is null), but there is a Spouse, I
want to be able to manually enter the spouse's name in Spouse.

My set up works as intented. But. When I create a new record, Spouse
appears as #Name? so of course I've done something incorrectly. How can I
have the functionality I need with Spouse and ComboSO without Spouse being
automatically populated with #Name? at a new record? Thanks!