ralphralph07
MIS
Hi
I have combo box on a form called SourceID and a command button that opens the Frm_Source if a user needs to add a new record.
when the Frm_Source form is closed the SourceID Combobox doesn't refresh? My current code is:
Code:
Private Sub Cmd_AddSource_Click()
DoCmd.OpenForm "Frm_SourceClaim", acNormal
DoCmd.GoToRecord , , acNewRec
Me.SourceID.Requery
I've tried putting the openform as a dialog but this then refreshes the whole form and sets me on a new record?
Thanks for any pointers
Ralph