Connecting Tech Pros Worldwide Forums | Help | Site Map

can't assign a value to this object

Newbie
 
Join Date: Aug 2009
Location: Romania
Posts: 15
#1: Sep 1 '09
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

Expert
 
Join Date: Jul 2008
Location: Maryland
Posts: 1,186
#2: Sep 1 '09

re: can't assign a value to this object


Is the form in datasheet view or single/continous view? If the error occurs during code execution, could you post the relevant code?
Newbie
 
Join Date: Aug 2009
Location: Romania
Posts: 15
#3: Sep 1 '09

re: can't assign a value to this object


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.
Reply