C
charles.kendricks
I have a form which is used to input customer data and has a control
which is set to record the current user using the CurrentUser()
function tied to the Before Insert event of the form. The same form
contain a lookup button with which I can close the form and reopen it
with an openargs that causes the form to us a dataset tied to a query
which requests the customer last name and returns matching records.
The problem is that when I click the button to look up customers I get
an error stating that "You can't assign a value to this object". In
the VBE the line that I used to assign the current user to a field in
the record is highlighted. I'm confused.
which is set to record the current user using the CurrentUser()
function tied to the Before Insert event of the form. The same form
contain a lookup button with which I can close the form and reopen it
with an openargs that causes the form to us a dataset tied to a query
which requests the customer last name and returns matching records.
The problem is that when I click the button to look up customers I get
an error stating that "You can't assign a value to this object". In
the VBE the line that I used to assign the current user to a field in
the record is highlighted. I'm confused.