Hi,
I am trying to make my Form as efficient as possible.
Using a combo box I have it set up so that when I enter a new company name which is not already on the drop down box, it will save that entry to my table.
However, when I go to use the form again, I want that new entry to show up on the drop down box as an option.
I tried selecting the option 'I want the combo box to get the values from another table or query' option, but when this is selected it does not allow me to add a new name to the drop down box in the form if it isn't already available in the table (which kind of renders the point of the form useless).
Any help?
Many thanks.