Subform not saving

[GlenMcCabe]

I have 2 virtually identical subform structures.

Onward referrals and interventions

Each has a lookup field which selects the onward referral or intervention and in each case a date and notes are added. The onward referral subform works perfectly but the intervention subform creates a row which saves the notes and dates but not the id of the intervention.

I get the following error
[0] :
===USER==========

globeadmin

===PDO MESSAGE===

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `id` = '1514'' at line 1

===SQL===========

UPDATE referral_interventions SET WHERE `id` = '1514';

===BACK TRACE====

C:\xampp\htdocs\nubuilder4\nudata.php - line 348 (nuRunQuery)

C:\xampp\htdocs\nubuilder4\nuapi.php - line 52 (nuUpdateDatabase)

ID is the row number which is tobe created or updated.

I have checked structures etc and cannot see differences between the subform structures. I have inserted values into the id field but these do not display in the subform even though they are in the table.

Thanks

[kev1n]

Hi,

Check the spelling of the fields, upper and lower case, additional spaces.

[GlenMcCabe]

Thanks Kevin

Tried that but all field names have been chosen using the up and down arrows to toggle through field names.

I did try re selecting all but no difference.

Will try deleting the subform and try again.

Glen

[GlenMcCabe]

Recreated form and subform. They look identical to originals but happy days it is now working.

[admin]

.