Clear combo box selection.

[Homegrownandy]

the text boxed to the right here are showing the value of the combo box to the left. (or the value of the textbox on the last one.)

The combo box next to card_name1 only shows cards which the selected person does not have already. So it can be used to add them.






That's all well and good. But.. If you look to the textbox referencing the combo box. Its still saying 6. This is from the previous entry.

The combo box itself updates so it does not show the card name. But it still holds the value of the last card.

Each combobox has refresh/requery I don't know what else to try. If anyone could suggest something.

[Bob Fitz]

What is the Record Source property for the text box showing "6". Have you tried to requery that text box.

[Homegrownandy]

the control source for that textbox is literally the combo box. =[Combo26]

The whole form refreshes and requerys on any change to any combobox.

The combo box appears to work as the text does disappear. but its holding the ID. I'm pretty lost.

[Homegrownandy]

I can probably change the macros to vba and set it to null... Ill see.,

[Homegrownandy]

The form is behaving very strange. asking for parameters when it should not have. I remade the form exactly the same and added some VBA to reset values. All good now.

[Bob Fitz]

The form is behaving very strange.

Often a sign of corruption

[Homegrownandy]

Would you investigate further or you think its okay with the new form behaving itself?

[Bob Fitz]

I would suspect that the problem was with the form that has been deleted. I personally would create a new blank db and import everything from the existing db. Would be interested to hear the views of other users that more experienced with corruption.

[Homegrownandy]

Thanks for your input.