>>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.

And for enter new company add this code in the valid event from the combo.

If This.ListIndex = 0 AND !EMPTY( This.DisplayValue )
* Your append code
This.Requery()
Endif

Cemal