If, by "the combo box will not let me actually make a selection," you mean that when you click on a selection nothing happens, it's probably related to one of the Form's properties.
The Access Gnomes, in their infinite wisdom, look at the act of using of a Combobox as a form of Editing a Record; hence if AllowEdits is set to No/False, they cannot be used!
FYI, if you need to
- Use a Combobox
- Not allow editing of Records
the workaround is to
Set AllowEdits to Yes/True and Lock or Lock and Disable all of the Controls on the Form.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007