D1=ALLT(THISFORM.COMBO1.DISPLAYVALUE)
D2=ALLT(THISFORM.TEXT1.VALUE)
D3=ALLT(THISFORM.TEXT2.VALUE)
D4=ALLT(THISFORM.TEXT3.VALUE)
D5=ALLT(THISFORM.TEXT4.VALUE)
D6=ALLT(THISFORM.TEXT5.VALUE)
D7=''
D7A=ALLT(THISFORM.COMBO2.DISPLAYVALUE)
D7B=ALLT(THISFORM.COMBO3.DISPLAYVALUE)
D8=ALLT(THISFORM.COMBO4.DISPLAYVALUE)
D9=ALLT(THISFORM.TEXT10.VALUE)
DA=ALLT(THISFORM.TEXT11.VALUE)
DB=ALLT(THISFORM.TEXT12.VALUE)
DC=ALLT(THISFORM.TEXT13.VALUE)
DD=ALLT(THISFORM.TEXT14.VALUE)
DE=ALLT(THISFORM.TEXT15.VALUE)
DF=ALLT(THISFORM.TEXT16.VALUE)
DG=ALLT(THISFORM.TEXT17.VALUE)
DH=ALLT(THISFORM.TEXT18.VALUE)
DI=ALLT(THISFORM.TEXT19.VALUE)
DJ=ALLT(THISFORM.TEXT7.VALUE)
DK=ALLT(THISFORM.TEXT8.VALUE)
DL=ALLT(THISFORM.TEXT9.VALUE)
DM=ALLT(THISFORM.TEXT20.VALUE)
DN=ALLT(THISFORM.TEXT21.VALUE)
DP=UPPER(ALLT(THISFORM.COMBO2.DISPLAYVALUE)+" "+ALLT(THISFORM.COMBO3.DISPLAYVALUE))

LCSQL1="INSERT INTO DUMMY (SUBSNAME, ADDRESS, TEL_NO, CONTACT_PERSON, POSITION) VALUES (?D1, ?D2, ?D3, ?D4, ?D5)"
=SQLEXEC(filehandle,LCSQL1)

LCSQL2="INSERT INTO DUMMY (CODE, OBJECT_ID, BRAND, MODEL, EQPT_TYPE) VALUES (?D6, D7, ?D7A, ?D7B, ?D8)"
=SQLEXEC(filehandle,LCSQL2)

LCSQL3="INSERT INTO DUMMY (TRUNKS, LOCALS, EXT,ACCEPTED, INSTALLED, SUPPLIER) VALUES (?D9, ?DA, ?DB,?DC, ?DD)"
=SQLEXEC(filehandle,LCSQL3)

LCSQL4="INSERT INTO DUMMY (EXCHANGE, AREA, AE, SALES_MANAGER, AFFCODE2) VALUES (?DE, ?DF, ?DG, ?DH,?DI)"
=SQLEXEC(filehandle,LCSQL4)

LCSQL5="INSERT INTO DUMMY (SEGMENT, GROUP, SERVICES, REVENUE, OBJECT_NAME) VALUES (?DJ, ?DK, ?DL, ?DM, ?DN, ?DP)"
=SQLEXEC(filehandle,LCSQL5)

Why is it that the five SPT commands I've used only one is only being executed and reflected on the Access table as my remote data source?