I don't know why this is happening. I am trying to create a combo box in the header of a form to select a record and filter the detail ie. search and pull up just that record. for some reason when I create the combo box in the header I'm only getting 2 choices not 3. I get I want the combo box to get values from a table or I will type in the values that I want. I don't get the 3rd option. To find a record based on the value I select. I have a sample database that I created with Richard in his tutorials and it works fine with that database, but doesn't in the one I'm working on...what am I doing wrong?

---

Reply from Alex Hedley:

See this tip.

See this thread.
Have you set the RecordSource of your Form to a SQL statement