megatronixs
Registered User.
- Local time
- Today, 09:00
- Joined
- Aug 17, 2012
- Messages
- 719
Hi all,
I have the below code to insert some data from a search form into the table according the record_id that is on the current open record from the from.
it tells me the ";" is missing, but it is there :-(
Any clue where I go wrong?
greetings.
I have the below code to insert some data from a search form into the table according the record_id that is on the current open record from the from.
Code:
CurrentDb.Execute "INSERT INTO tbl_recipients (forname, surname, employee_id, team_leader) Values ('" & strListResult & "', '" & strListResult2 & "', '" & strListResult3 & "', '" & strListResult4 & "') From tbl_recipients WHERE [record_id] = " & formrecordid & ";"
it tells me the ";" is missing, but it is there :-(
Any clue where I go wrong?
greetings.