David,

I suspected that...in the rowSource, put:

table1.field1,field2,fiedl3...

Rather than:

table1.field1,table1.field2, etc...

< Update >
hmmm...I just noticed you said the rowSource is current table. If you want the rowsource to be the table, you need to change the rowSourceType. I prefer to go with fields, or SQL-statement, depending on the situation...



>The rowSource is the current table and rowSourceType is Fields.
>Thanks!
>
>>David,
>>
>>What do you have as the rowSourceType and rowSource of the listBox?
>>
>>>I have a look up table as a row source to a list box. For some reason I am getting a "Record out of range!" error when the form is refreshed. I have made sure the table is not at eof() and that the control source has a value. Any ideas?
>>>TIA!