access 2003 combobox problem.

By 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;


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

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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums