can't assign value

  • Thread starter Thread starter Mary Fran
  • Start date Start date
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!
 
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?
 
Back
Top