access lookup datamacro

[izzy2001]

seeking anyone who knows the answer to this one. I am trying replicate the northwind web database macro called getproductname getproductlist which is on the products table. this macro has a simple lookup action which looks up a record by a parameter being sent. (this comes the after update of of a form.



the customer order form has a productid combo box. on its after update it finds the product list. this UI macro just passess the product id to the data macro on the table and looks up the price for that id. then sets the value on the form. simple right? however i consistently get an error from the data macro on the table which says the "the identifier (enter field name here) could not be found"

in my case im selecting id and productname from my table. the syntax is correct. but when i run the macro i get "the identifier productname could not be found. ive been struggling with this for hours. and im using a working sample as an example. it simply wont work for me. can anyone help me out?

[hertfordkc]

seeking anyone who knows the answer to this one. I am trying replicate the northwind web database macro called getproductname getproductlist which is on the products table. this macro has a simple lookup action which looks up a record by a parameter being sent. (this comes the after update of of a form.

the customer order form has a productid combo box. on its after update it finds the product list. this UI macro just passess the product id to the data macro on the table and looks up the price for that id. then sets the value on the form. simple right? however i consistently get an error from the data macro on the table which says the "the identifier (enter field name here) could not be found"

in my case im selecting id and productname from my table. the syntax is correct. but when i run the macro i get "the identifier productname could not be found. ive been struggling with this for hours. and im using a working sample as an example. it simply wont work for me. can anyone help me out?

------------------------------------------------------------------------------------------------------------------------------
There are just too many possibilities without seeing some specifics.

[izzy2001]

the error indicates it cant field the field in the table. if i change this to return a value instead of a field name, the value is set on the the form as it should. so we know its not the UI macro on the form. that works. the questions is why the data macro cannot look up the field name in the expression.