INSERT INTO behaviour in Tab control with subforms Access 2010

[projectpupil7]

Hi, this code inserts some values from tblWorkItem(first tab page) into tblReactiveWorkPoList (second tab page). The code worksas expected but if I add in fields "Supplier" and"OrderNumber" the code fails i.e. doesn't copy the records over totblReactiveWorkPoList.No error messagesappear. Both "Supplier" and "OrderNumber" are text fields.



Before adding the fields I have this:

CurrentDb.Execute "INSERT INTOtblReactiveWorkPoList(ClientID, Address, AssetNumber, DescriptionOfWorks,InstructionReceived) VALUES(" & Me!ClientID & ", '"& Me!Address & "', '" & Me!AssetNumber & "', '"& Me!Description & "','" & Me!InstructionReceived &"')"
Forms!frmReactiveTracker.frmReactiveWorkPoList.Req uery


After adding the fields I have this:

'CurrentDb.Execute "INSERT INTOtblReactiveWorkPoList(ClientID, Address, AssetNumber,DescriptionOfWorks,InstructionReceived , Supplier, OrderNumber ) VALUES(" & Me!ClientID &", '" & Me!Address & "', '" & Me!AssetNumber& "', '" & Me!Description & "','" &Me!InstructionReceived & "','" & Me!SUPPLIER & "','"& Me!OrderNumber & "')"



Any offers of help please‼‼‼‼! ???????????

[June7]

Why is data duplicated between tables?

Need a space between INTO and tblReactiveWorkPoList. Is there really a space in your code and it just did not post here correctly?

Except for lack of spaces causing run-together, I don't see anything wrong with syntax.

If you want to provide db for analysis, follow instructions at bottom of my post.

[projectpupil7]

I have attached a zip file for assistance."Surveyors Workload for forum"

Duplicated data is there at clients adament request even though reservations
have been explained.
Yes there is a space after INTO (see in VB code).
In Reactive Tracker pick "Ian Hatton".
Click on Add Work Item button.
Enter details in form Add Work Item and click close.
On close Add Work Item fields should have copied accross to Reactive Work PO
subform.

Thanks for your help.

[projectpupil7]

Sorry VB password is "pcc"

[June7]

The field in tblReactiveWorkPoList is ORDERNO, not OrderNumber.


Advise not to use all caps in naming convention.

[projectpupil7]

Thanks June7, I thought I had changed all the fields but obviously not. So a fresh pair of eyes was very helpful. PROBLEM NOW SOLVED.

Happy Xmas to you and ALL forums staff and visitors.