can't assign value

M

Mary Fran

Hi - I have a macro that is trying to set the value of a bound control on a
form to the following: nz(DLookUp("CalcPrice","qryBFrptAllComplete","ID=" &
[Forms]![frmInventory]![ID])). The macro halts with the "can't assign value
to object" error and then when you try it again it works without error. The
record is saved prior to this step. Why does it work the second time but not
the first time through?

THanks!
 
M

Mary Fran

Addendum to post - the set value command follows an update query. If I save
the record and repaint the form I can run without "you can't assign value..."
error - why is that?
 

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

Assign value to bound text box 1
Can't Assign Value to this Object 5
Can't assign a value ... 5
Can't assign a value to object 6
Can't assign value error 2
On Close assign a value 2
You can't assign a value to this object 3
Error ==> You can't assign value to this object 1

Top