Combo box not showing all three options

[snoopy4801]

I'm sure this is a basic and common question, but I can't seem to find the answer for it.

When i go to create a combo box in my form the option of "Find a Record on my form based on the value I selected in my combo box" is not appearing and this is the option I need.

Any tips/suggestions?

 

[VilaRestal]

You need to turn on the 'Use Control Wizards' before you draw the combobox. (It's a button on the Design ribbon next to the control toolbox)

The wizard creates a macro (a horribly coded macro) to do that.

Or if you have the wizard with only two options then that's because the form doesn't have a record source