I have an Access 2002 project that is linked to an SQL Server 2000 database that has Numeric primary keys with a precision of 38 and a scale of 2. This allows me to create ID numbers like 1.01, 2.01 and so forth.
I am trying to create a Combo Box that has a rowsource that points to one of the tables. It has multiple columns and the first column holds the primary key (the Numeric column mentioned above).
The problem is that when I run the form the combo box lists each Primary key as zero when this is not the case. The only way to get it to work is to Cast the primary key field as a Float datatype but I don't want to do this because it slows performance.
Any help would be greatly appreciated,
Jake
I am trying to create a Combo Box that has a rowsource that points to one of the tables. It has multiple columns and the first column holds the primary key (the Numeric column mentioned above).
The problem is that when I run the form the combo box lists each Primary key as zero when this is not the case. The only way to get it to work is to Cast the primary key field as a Float datatype but I don't want to do this because it slows performance.
Any help would be greatly appreciated,
Jake
