id="info"

Question

Locked

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;

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.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
2 total posts (Page 1 of 1)  

Software Forums