Very Annoying Combo box problems

[Rich]

I recently created a mutitab form for a database. On one
of the pages I built a combo box with user specified
values. Once one of these values are selected a command
button opens a filtered form based on what value was
selected in the combo box. The problem is that the combo
box refuses to highlight or select any of the values thus
negating the entire point of the excersise. I have used
similar methods before with success so I wonder why am I
experiancing difficulties. I am a relative newbie to
access (comfortable with using the gui interface but no
coding experiance) and any help would be appricated.

 

[Rick Brandt]

I recently created a mutitab form for a database. On one
of the pages I built a combo box with user specified
values. Once one of these values are selected a command
button opens a filtered form based on what value was
selected in the combo box. The problem is that the combo
box refuses to highlight or select any of the values thus
negating the entire point of the excersise. I have used
similar methods before with success so I wonder why am I
experiancing difficulties. I am a relative newbie to
access (comfortable with using the gui interface but no
coding experiance) and any help would be appricated.

A couple possibilities...

The ComboBox has Locked property = True
The Form has AllowEdits property = False

 

[Ken Snell]

Or the combo box is bound to a field in the form's recordsource query and
that query is nonupdatable.

 

[Rich]

The Form has AllowEdits property = False

Thanks, this worked perfectly.