Unanswered: How can I get a Combo box to reflect the changes made to a table?
I have two forms called:
On the [ClientDetailsFormNEW] form I have a combo box called PPI with the following row source:
SELECT PrimaryPresentingIssue.PPI FROM PrimaryPresentingIssue ORDER BY PrimaryPresentingIssue.PPI;
And a button (called [PPIBTN]) which opens the [aPrimaryPresentingIssueTypeF] form.
The [aPrimaryPresentingIssueTypeF] form is used to add/edit/delete details on the PrimaryPresentingIssue Table.
The idea is that when the user opens the [ClientDetailsFormNEW] form and clicks on the PPI combo box, if they notice that they need to add a new record, they can simply click on the [PPIBTN] button (which opens the [aPrimaryPresentingIssueTypeF] form), add the new record, close the form and then click back onto the PPI combo box to see the updated listing.
My problem is that when I click on the PPI combo box (after adding a new record using the [aPrimaryPresentingIssueTypeF] form ) the PPI combo box is not reflecting the changes made.
How can I make the PPI combo box reflect the changes made?
You need to call the requery method of the combobox. You'll probably need to call it from the PPIBTN button after all the other code as ran. Something like PPI.Requery - or whatever you named the PPI combobox.