Default Value in a Combo Box

[eknotts]

I have a Form (Job) and a Sumform (Job Details). The Subform has all the component records that make up the Job. The Job form has a Combo Box that allows the selection of the "Job Color"; in the Job Details for the various components of the Job, I have a Combo Box that allows the user to select a color (which may be different from the Job Color)for a specific component of the Job. I would like to make the "Default Value" of that Combo Box for the specific component to be the "Job Color" selected in the "Job Form". How do I do this?

 

[jebry]

Hi!

Open the form that you are using as a subform in design view and put this code in the Form_Current event procedure of the form:

If IsNull(Me!cboDetailColor) = True Then
Me!cboDetailColor.Value = Me.Parent!cboJobColor.Value
End If

hth
Jeff Bridgham
bridgham@purdue.edu

 

[jebry]

Hi!

Open the form that you are using as a subform in design view and put this code in the Form_Current event procedure of the form:

If IsNull(Me!cboDetailColor) = True Then
Me!cboDetailColor.Value = Me.Parent!cboJobColor.Value
End If

hth
Jeff Bridgham
bridgham@purdue.edu