Solved How to show relevant record to subform using combo box from main form

[rehanemis]

Hi,
I have main form with subform. I would like to show relevant record after choosing value from combo-box. The matching field type is text.

 

[theDBguy]

Is it really a subform? If so, you should be able to link the main form with the subform by using the Linked Master and Child Fields to display the related records in the subform.

 

[rehanemis]

The

Is it really a subform? If so, you should be able to link the main form with the subform by using the Linked Master and Child Fields to display the related records in the subform.

Main form doesn't having the fields linked with master / parent.

 

[theDBguy]

The

Main form doesn't having the fields linked with master / parent.

So, is it an unbound main form then? Even still, you could link the subform using a Textbox or Combobox on the main form.

 

[rehanemis]

So, is it an unbound main form then? Even still, you could link the subform using a Textbox or Combobox on the main form.

how can I? Please share.

 

[theDBguy]

how can I? Please share.

Just use the Linked Master and Child Fields properties. Try entering the name of the Combobox as Master and the Field's name as the Child.

 

[rehanemis]

Just use the Linked Master and Child Fields properties. Try entering the name of the Combobox as Master and the Field's name as the Child.

not good in , didn't find.

 

[theDBguy]

not good in , didn't find.

What "didn't find?" The related record?

 

[arnelgp]

add code to the Combobox AfterUpdate event:

Private Sub comboName_AfterUpdate()
If Me.comboName.ListIndex > -1 Then
    'valid value from combobox
    With Me.RecordsetClone
        .FindFirst "[Employee ID] = " & Chr(34) & Me.comboName & Chr(34)
        Me.Bookmark = .Bookmark
    End With
End If
End Sub

replace comboName with the name of your combo.

 

[zeroaccess]

You cross-posted this here: https://www.access-programmers.co.u...anging-field-type-from-number-to-text.311337/

And the answer several have given you is to link the Master and Child fields.

Best practice is to link them with the Primary and Foreign keys, which would be number types. The EMP ID does not have to be the Primary Key. Just set the PK to Autonumber and forget about it, then link them.

 

[MajP]

As DBGuy said. Assume the combo box name is cmboEmpID and the subform field is empID. Then the properties look like

Link Master Fields: [cmboEmpID]
Link Child Fields: [EmpID]

no code required.