VBA default combobox value after requery

[crododo]

Hi,

I have this code:
If Me.OpenArgs = "frmAddChecklist" Then
Set ctlCombo = Forms!frmAddChecklist!cbDEPARTMENT
ctlCombo.Requery
End if
And this code is done after I added new value to table, and now I want that new value to be used as default one, how can this be done?

Thanks

 

[CJ_London]

Try

ctlCombo.Default = Forms!frmAddChecklist!cbDEPARTMENT