can't assign a value to this object

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Kan09
    New Member
    • Aug 2009
    • 19

    can't assign a value to this object

    i made a mdw file with the user level level wizard and asigned a few users to the new data users work group.
    When inserting data into the forms a pop up msj appears with the "can't assign a value to this object". The object in cause is a "stop time" column in the table with the time function in the vba code. The users form the full data users cand input that kind of data.

    Why? and what do i do?


    Txs
  • ChipR
    Recognized Expert Top Contributor
    • Jul 2008
    • 1289

    #2
    Is the form in datasheet view or single/continous view? If the error occurs during code execution, could you post the relevant code?

    Comment

    • Kan09
      New Member
      • Aug 2009
      • 19

      #3
      The form is in single view with a subform atached witch gets requeried every time data is enterd into the main form and the cmd button "save" gets clicked (the subform is there only to show the last entries made by the user).
      I don't think there's anything wrong with the code...it works perfect for the admin users or the full permision user group...the problem occures only when i try to enter data logged in with a user form the "new data users" workgroup. At first i thought the problem was that the new data users can only insert and read data, they can't update or delete it. But that was not the case because the time function is inserted into the table on a click event (the save button) and not trough an update query.

      I would paste the code..but i'm not at my office right now.

      Comment

      Working...