Lookup wizard not working

[latex88]

I tried to chosee Lookup Wizard as data type in my table so I can have drop-down options from another table. However, I received an error message, "ActiveX component can't create object". What does this mean, please help

 

[Pat Hartman]

Search this site for that message. Also search the knowledgebase. I have seen it but I can't remember the solution.

IMO, the lookup wizard will cause more problems than it solves. It is simply a crutch for absolute newbes who haven't yet learned how to use the querybuilder. I'm assuming that since you found this forum, you want to move beyond that state. My recomendation is to NEVER use the lookup wizard in a table. It simply causes problems when you eventually get to working with queries and VBA. If you want to see the "lookup" value, create a query and make the join yourself. Then open the query rather than the table.