Solved Cannot get comboBox on subform to refresh. (1 Viewer)

[HillTJ]

'Hi, on 'tblOrganisations', I have a tabbed 'subform' on tab 'Personal' of that subform is a combobox 'cboClassification' that I wish to update whenever a user selects the button 'BttnOpenCategory_Jobs' on the main form. This opens up form 'frmOrganisationCategory_JobRoles' , checks that 'tblOrganisation' is opened from 'tblOrganisations (I intend to use this form elsewhere), and if so, I wish to add the new record to cboClassification. Seems simple, but I cannot get it to work.

Appreciate your assistance as always.

 

[Edgar_]

In tluJob_Classification subform

Private Sub Form_AfterUpdate()
    Form_frmEmployee_subform.cboClassification.Requery
End Sub

See if it helps

 

[moke123]

see if this works or use the not in list event of the combo

Private Sub BttnOpenCategory_Jobs_Click()

    DoCmd.OpenForm "frmOrganisationCategory_JobRoles", acNormal, "", "", , acDialog

    Me.frmEmployee_subform.Form.cboClassification.Requery
  
End Sub

 

[HillTJ]

Gents, thanks. Will let you know.

 

[HillTJ]

Went with @Edgar_ recommendation works fine. Appreciate it. The project continues......