after update event error

[Guest]

hi guys!

I have a form with the following fields:
itemcode, itemname, price

my after_update code:

me![itemcode]=me![itemname].column(1)
me![Itemcode]=me![price].column(2)

now, when i use the form and enter the itemcode, an error message saying "an
expression you entered as the event property setting produced the following
error: a problem occurred while microsoft accress was communicationg with the
OLE server or ActiveX control."

what could have been the problem? do i need to add something on my project
references (VBA) or something? Please help.

--
My sincerest thanks. . . and may the good Lord bless you always and give
you more knowledge and intelligence to share with us novice. Thank you very
much!

Resty A. Morales

 

[Lynn Trapp]

me![itemcode]=me![itemname].column(1)

me![Itemcode]=me![price].column(2)

Is [itemname] a combobox or a listbox? If not then the .column property
makes no sense here. Also, why are you setting the value of [itemcode] in
one line and then changing it immediately in the next line?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html