When I add a search combo box to the sample DB that I built for the course I get the 3 options in the wizard. When I add a combo box in a DB that I have built for myself I only get the first 2 options. Can you tell me why? Thanks.

---

Reply from Richard Rost:

This is a quirk in Access. The third option (to create a combo box to SEARCH with) only appears if your form is bound to a TABLE or QUERY. It will NOT appear for unbound forms, or if your form's RecordSource property is an SQL statement.

Unfortunately, the default method that Access 2007 and 2010 create new forms is by making an SQL statement in the RecordSource (which I completely HATE, by the way)... so you have to manually change that to a Table or Query name for that third option to work.