Help! Combo box will not allow me to re-select from list.

[UncleNel]

1. I have Combo box that use a query to provide a select list.
2. "After Update Event Procedure" uses a Find Method to populates fields based on the combo box select.
3. Work fine. But,
4. If I try to change the initial select, I get the status line message "To change this field, first save the record".
5. If I click off the record or click on the record selector, I can update the field.
6. What do I have to do after the initial select (after update event) or prior to the combo box select to make it where I can go back and change my initial selection?

All suggestions welcomed.

Thanks

 

[SBendBuckeye]

Are you sure you aren't in before update event code instead? You can't make changes there without getting errors.

Good Luck!

 

[UncleNel]

SBendBuckeye, Thanks for getting back..

No, I'm not in a [before update] event. [Before Update] event runs a macro to timestamp the record for change.

I used the [After Update] event because I have to wait for the combo box selection to be made before I can use the Find method to get the record.

A third event for [Double Click] brings up the selection in its own form. This is so that the user can see additional information.

I read somewhere that because I used SQL that the combo box has become bound to it. If this is true, is this my problem, and if it is, what must I do to make the combo box become unbound?

Does this help?

 

[Rolliee]

To 'unbind' a combo box simply delete the 'control source.' Then you must code the results of the combobox to get the goodies.

Rollie E

 

[Rolliee]

To 'unbind' a combo box simply delete the 'control source.' Then you must code the results of the combobox to get the goodies.


Are you usiing the combo to find a record or change a record. The wizard does the later if you check put the results in a field. This would explain why a save was required - yo changed the data. You need to code a find.

Rollie E