Linked Table to SQL Server 'No Current Record'

[swalsh84]

I searched for about an hour on this and couldn't find an answer that worked for me.



I have one main table that joins to several 2 column tables (users, status, priority, etc.)

I have comboboxes for each of these items to select from. All of them but one works. I have copied and pasted a working one. Double and triple checked table structure. I am sure I have a primary key and a unique index on my server table, but I can't seem to find out why this particular combobox will not let me update it.

I have one function in this project called getProjects that shows the stored procedure code.

I attached a test copy, but converted the server tables to local tables. Any help on this?