combo box corrupts table

[ronmalt]

I'm using a form with a combo box to select a name and print a report
for that customer. After I choose the name and print the report I
notice that the table is messed up. For example if I choose Ed Simon
from my combo box the report prints fine.The combo box lists fullnames
such as Bob Baley, Ed Simon etc. If I choose Ed Simon from the combo
box list the name Ed Simon replaces the lastname Baley in the first
record of the table. Then my combo box will list a Bob Ed Simon.I can't
figure out what to do. Every time I select a different name for a
report it will do the same thing.
So the first record in the table is corrupted each time I select a name
from the combo box
Any help would be appreciated.

Thanks,
Ron Greenbank

 

[Duane Hookom]

If you are selecting a record to filter your report, the combo box should
not have a control source. The control source value will update/edit the
table which I don't think you want to do.

The combo box should be unbound.

 

[ronmalt]

Duane, Thanks for the tip. Everything works fine now. I had the control
source set to the lastname field.

Ron