Combo box text will not update

[MetalicPrism]

I have used a combobox to select, from and add records to a table. It works great for this, however when the data control for the form is used to move to the next record. The combobox still displays the previous selection. If I bind the control to the field then Access will not alow selection from the combobox anymore. If I try to clear the field during the on current event of the form Access will not allow this either as it produces an error complaining about trying to alter the PK...... Any ideas?

 

[Eupher]

This is normal behavior for an unbound combo. You can't set it to Null if it's bound and is a primary key in your table. You can set it to Null in the form's OnCurrent event if it is unbound. How are you populating the combo (when unbound)?

Ken S.

 

[MetalicPrism]

Hello Eupher

I am populating the combo box by the row source of the box.

The command is

SELECT Parts.PartID, Parts.[Part#] FROM Parts ORDER BY Parts.[Part#];

I did try to null out the text property of the combo on the current event of the form but it produces an error. I will double check that I did not do that while it was bound.

Thankks for the help

 

[MetalicPrism]

Thanks Ken

It works great when I Nulled the combo box. Interesting that you do not Null the text property specifically. Just the whole combo box

 

[RoyVidar]

The .Text property is String, which can't be set to Null, while the .Value property, which is the default property, and what is used when assigning "the whole control", is a Variant.

Roy-Vidar

 

[MetalicPrism]

Yes thank you I was at the time tring to set the text property to what some would call a NULL string ... which would be an empty string. Thanks for the tip on the value property, it is good to know.