Combo to "Find a record..." - FORM with SQL

[BSkulason]

Wizard to create ComboBox in Forms doesn't allow you to select the option
"Find a record ..." if the forms record source is an SQL statement.

WHY is this limitation present in the wizard ??

You can create the combo when record source is a table or Query and later on
change it into SQL without compromising funcionality of the Combobox.
So WHY is the Wizard restricted in this way ?

 

[Allen Browne]

Is the primary key field returned by the query?

In any case, you can use code like this without the wiz:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html