error message - 'number of query values and destination fields are not the same?' (1 Viewer)

[geoff lea]

error message 'number of query values and destination fields are not the same?'

this should search the field [cv details] in the table [Curriculum Vitae] for the searchText and then append the results i.e. candid and skillid into the [tblCandAndSkill]

sqlstring = "insert into [tblCandAndSkill]" _
& " (candid,skillid)" _
& " SELECT [Curriculum Vitae].CandID" _
& " FROM [Curriculum Vitae]" _
& " WHERE ([CV details] like '" & searchText & "')"



thanks for the pointer i had left out the skillid

SELECT [Curriculum Vitae].CandID, skillid"

 

[Sergeant]

For starters, you've declared two destination fields (candid,skillid)...but you're only trying to put a value into 'candid'. It is looking to fill every declared destination field.