I have a form that contains an unbound combo..ClientCombo that is populated using
SELECT ClientDetails.ClientRef, ClientDetails.Surname, ClientDetails.Forename, ClientDetails.LARef
FROM ClientDetails
ORDER BY ClientDetails.Surname, ClientDetails.Forename;
using
Dim Result
Dim Msg As String
‘ Exit this subroutine if the combo box was cleared.
If NewData = “” Then Exit Sub
Msg = “‘” & NewData & “‘ is not in the list.”
Msg = Msg & “Do you want to add a new Client?”
If MsgBox(Msg, vbQuestion + vbYesNo) = vbYes Then
DoCmd.OpenForm “AddNewClient”, , , , acAdd
I open a form AddNewClient
populate the form
run a macro using a buttons onClick property
Goto record
close
But when I close the form and return to the form containing ClientCombo I can’t get the combo to update to show the added record.
I have been searching for a solution for days…literally.
Please put an old man out of his misery.