Error: does not allow new entries. I'm not trying to Add, only Update.

[addienaon]

Hello,

I am trying to update a record in a table using a form, but I'm getting the error: does not allow new entries. I have no doubt that the id I'm testing with exists in my database and I've set my table to only allow updates. In addition, the only field I want the user to fill out, "Rating", doesn't show up in the form. I must me making a silly mistake, any help is much appreciated! 

Form:

I have set my table to only allow updates. 

I've created a behavior to pass the id from a different table. 

Table columns:

Thank you for your time! 

[Marc_Dillon · Accepted solution]

LINKTOFORM is only for adding new entries. You can use LINKTOROW to get to the Form View for a specific record, but you can't pass any values into it as with LINKTOFORM.

[Marc_Dillon · Accepted solution]

LINKTOFORM is only for adding new entries. You can use LINKTOROW to get to the Form View for a specific record, but you can't pass any values into it as with LINKTOFORM.

[addienaon]

Ha! The hours I've spent on such an avoidable error, now I know. Thank you for the quick response 😊

[addienaon · Accepted solution]

Here's how I fixed my behavior for anyone looking. 

LINKTOROW(ANY(SELECT(dbo.InspexPutView[id],[Id]=[_THISROW].[Id])),"Rating")