Populating main form after changing selection

[Greg]

On my main form I have fields displaying ticket #, group name ticket is
assigned to and phone number for respect group. If I don’t have a phone
number I am not displaying field for phone number.

On same form I also have a subform on which I am displaying only open tickets.
After clicking on ticket in a subform ticket is populated to fields in a
main form, however in addition I would like to populate fields for a phone
number or make them invisible when there is no phone number.

Here is a code I am using:

Private Sub Form_DblClick(Cancel As Integer)
Dim lngTicket As Long

lngTicket = Me.[Ticket #]
Me.Parent.Requery

Me.Parent.Recordset.FindFirst "[Ticket #]=" & lngTicket
Forms![Remedy Tickets]![Status].SetFocus
End Sub


I have a combo box I called Assignto and after selecting specific group
phone numbers are provided for each group. I noticed that when I select
specific ticket from subform main form is populated, but when I changed
assigned group, phone number doesn’t change and it is a previous selection
phone number. How I can update phone numbers when I want to change group
name? Thanks