Questions

access 2003 combobox problem.

Tags:
+
0 Votes
Locked

access 2003 combobox problem.

pascal3
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.