Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
access 2003 combobox problem.
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.