Hi there
I got a bugging problem..
I need to update a table from 2 different sources at the same time.
I have on the table(TESTSRESULTS) 3 fields: recnum,testcod,testap
recnum(numeric data) is on the form and holds the order.
testcod and testap are supposed to come from table TESTS.
What i mean is to create something like:
'strSql = "Insert Into testresults(testcod) Select testcod From tests Where testcod= 401 ;"
'DoCmd.RunSQL strSql
'strSql = "Insert Into testresults (testcod) Select testcod From tests Where testcod= 440 ;"
'DoCmd.RunSQL strSql
this will create two different records.
and the run update
recnuminklita = me!recnum
'dbs.Execute "UPDATE testresult Set testresults.recnum = recnuminklita where isnull(ansdate) ;"
can somone help solving that problem please
Thankx alot in advance
Noam
I got a bugging problem..
I need to update a table from 2 different sources at the same time.
I have on the table(TESTSRESULTS) 3 fields: recnum,testcod,testap
recnum(numeric data) is on the form and holds the order.
testcod and testap are supposed to come from table TESTS.
What i mean is to create something like:
'strSql = "Insert Into testresults(testcod) Select testcod From tests Where testcod= 401 ;"
'DoCmd.RunSQL strSql
'strSql = "Insert Into testresults (testcod) Select testcod From tests Where testcod= 440 ;"
'DoCmd.RunSQL strSql
this will create two different records.
and the run update
recnuminklita = me!recnum
'dbs.Execute "UPDATE testresult Set testresults.recnum = recnuminklita where isnull(ansdate) ;"
can somone help solving that problem please
Thankx alot in advance
Noam
