INSERT table issue

  • Thread starter edisonl via AccessMonster.com
  • Start date
E

edisonl via AccessMonster.com

Hi,

I have a Generic form that consist pending costs awaiting for superior
approval.
___________________________________________________________________
Private sub ApprovalButton_On_Click

if MyForm.SubFormName.CostingType = "MachineCosts" then
'Execute SQL INSERT Statement to MachineCosts_Table

elseif MyForm.SubFormName.CostingType = "MaterialCosts" then
'Execute SQL INSERT Statement to MaterialCosts_Table

elseif MyForm.SubFormName.CostingType = "OfficeSupplyCosts" then
'Execute SQL INSERT Statement to OfficeSupplyCosts_Table
End if

End Sub
___________________________________________________________________

Problem : Machine Costs are able to execute SQL but MaterialCosts aint able
to.
Tried: Copies all field in SubformName exactly into all table respectively
(Material, Machine, Office Supply)
Results: OK for Machine, Failed for Material & OfficeSupply

Can anyone provide some guide ? Thanks..

Edison
 
Top