>I need a drop down combo that lists all of the distinct values already in that field, for example, selecting a company from a list of companies already in the database, you also need to be able to enter a new company. How do I do this?


The quick and dirty way is to set your rowsource to 3 - SQL and the rowsource to SELECT DISTINCT company FROM yourtable INTO CURSOR cCompanySQL. Set the controlsource to company field in your table.