Access 2007 - Combo Box selection is putting record into edit mode

[Tammy]

Hi,
I have a combo box on a form that is set up to find a record based on what's
selected from the combo box. That works, however, after retrieving the
record, it keeps putting my data into edit mode (the pencil appears).

I want to make a selection from the combo box and view the record, not have
the combo box attempt to fill in a field.

I haven't had this problem before, so am not sure what info to give you. I
have other forms where I've added these types of combo boxes, but have never
encountered this problem. There must be something different about this form,
but I'm not sure where to start looking...

Any suggestions will be greatly appreciated! Thanks!

 

[Dirk Goldgar]

Hi,
I have a combo box on a form that is set up to find a record based on
what's
selected from the combo box. That works, however, after retrieving the
record, it keeps putting my data into edit mode (the pencil appears).

I want to make a selection from the combo box and view the record, not
have
the combo box attempt to fill in a field.

I haven't had this problem before, so am not sure what info to give you. I
have other forms where I've added these types of combo boxes, but have
never
encountered this problem. There must be something different about this
form,
but I'm not sure where to start looking...

Any suggestions will be greatly appreciated! Thanks!

It sounds to me like your combo box is bound -- that is, it has a field as
its ControlSource. Normally, a combo that is used for navigation would be
unbound; that is, its ControlSource would be blank.

 

[Tammy]

Hi Dirk,

Thank you very much for your response! It *was* bound to a field. I ended up
redoing the combo box, and this time a control source was not automatically
entered by the wizard. I must have really had a good time the first time
around, because, I swear, the steps were the same. Thanks again for pointing
me in the right direction - really appreciated it!!
Have a wonderful week!