Run time error -2147352567 (80020009)

R

Rpettis31

I get this "The value is entered isn't valid for this field"; error.
This is from a button that pulls data from a subform. This button used to
work, and works on other records. So I am not sure as to why this is now
occurring.
I am using Access XP

This is my code
Private Sub cmdUpdateCost_Click() 'Syteline btn click event

' On Error GoTo Err_cmdUpdateCost_Click


DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
<<I get an error on each line of this code when I comment out and try to
resume>>
' Assign values from Syteline Std Cost fields
Me.txtFreightStdCost = Me.subfrmDebitCost!FrieghtCost
Me.txtStdDutyCost = Me.subfrmDebitCost!DutyCost
Me.txtStdMaterial = Me.subfrmDebitCost!MaterialCost
Me.txtStdMatlsCost = Me.subfrmDebitCost!UnitCost
Me.txtstdBrokerageCost = Me.subfrmDebitCost!Brokerage
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run time error '2001' You cancelled the previous operation 2
Run-time error 2147352567 (80020009) 0
HELP: Run-time error '-2147352567 (80020009): 3
runtime error 2147352567 (80020009) could not update, currently lo 0
Error 2147352567 2
Error 2237 8
vba coding 4
add one to a duplicated record that checks to see if one exists 0

Top