>The report runs fine when I'm working on my project, however, I've made an executable of my project, and when I choose a value in the combo and press preview - I get the error "the record is out of range" and no report is generated. (I know the combo value exists in the database) Does anyone have any ideas?

Jimmy,

Recreate the table indexes, a bad index is the single most common cause of that error.