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
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1
|
|