Run-time error 80020009

M

MTsang987

Hi,

I am getting an error
Run-time error '-2147352567 (80020009)':
You can't assign a value to this object

I have two forms (PO, Prod) with two corresponding forms (POItems,
Prod_List. From the

second form, I call a function (SetProduct) of the subform of the first form:

Forms("PO").POItems.Form.SetProduct Me.Prod_List.Form.ID.Value

SetProduct looks like:

Public Sub SetProduct(strProductID As String)
Me.ProductID = strProductID '''Fails here


Now we notice that this error does not occur on the machines that have mdac
version 2.6 (?) or lower, but it does occur on machines with mdac versions
that are newer.

Any help is appreciated.
 

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

Runtime error 80020009 0
Shell command produces a "Run-time error '5': Invalid procedure call or argumen 0
Run time error 1
Run time Error 12
Run-time error 2147352567 (80020009) 0
runtime error 2147352567 (80020009) could not update, currently lo 0
Run time error when adding new record 3
Error with no value 2

Top