Combo Box selection is changing the table fields

[GoingCrazy]

You all were kind enough to help me this morning with using a combo box to set the parameter for a report. I am now noticing that when I select something from the combo box and then change my choice and select something else that it changes a field in the table it is reading from. For example:
My combo box has 2 fields: code and name

When I select the code (the first time) it pulls up the right info for the report just fine. If I change my mind before I get the report and select a second code, it puts this code with the first description in my table. Meaning it erases the first code and replaces it with whatever I last chose. I hope this makes sense. Do I need to bind both fields to the combo box so they remain together or is there another property setting I am missing.

I'm open to suggestions.

Thanks for any help you might offer.

 

[CosmoKramer]

If you don't want data in bound controls to be edited when a form is in Form view or Datasheet view, you can set the form's RecordsetType property to Snapshot.

 

[GoingCrazy]

I just tried your suggestion and it doesn't allow you to make any selection in the combo box.

 

[CosmoKramer]

Is the combo box an unbound control? If it's not, it will update the source table?

 

[GoingCrazy]

That must be the problem...it is a bound combo box. I will change it and see what happens.

Thanks for your assistance.