Joel D Canfield wrote: >I've lately encountered what seems an oddity. On occasion (or all the >time, guess I'm not sure) if I assign the values of database fields to >variables in a different order from the order specified in the 'select' >statement (or perhaps it's in a different order from the database >design?) the fields which are out of order don't seem to have any value. >I'm specifying the field names in the select statement, not selecting >'*' > >Is order important in this case? > >joel > > it depends how you create your recordset. what are you doing in that respect?