I have a combo box in side a form that pulls data, the data in the table is filtered with this filter "00\-CCCCCCC"

When I go in the select statement for this Combo Box all the data looks right and the filter is in place. But when I am in the form and I click on the drop down it looses the filter and brings the numbers and letters together with out the "-" in between. This has a big effect on the auto type feature.

When I go into the tables the data is still filtered correctly.

Has anybody ever seen this before?


Examples

01-LEARGR = This is the correct way

01LEARGR = This is the wrong way