>I have a combobox linked to a field of type integer with rowsourcetype of 'sql statement'. When I run the form rather than show details from the record with the matching key it shows the details of the record whose record number matches the key field. Does anyone know what is causing this? Does anyone know a simple workaround?

Check the BOUNDTO property.

HTH!