Combo Box Error Stops Function

[Phred]

Access 2007. My skill level is moderate. Problem with combo box on Customer form. Not compiled, not split.



I built a standard combo box with the wizard to find a customer on the customer form. This automatically built the corresponding macro. You select the customer from the box and the related customer record appears on the form.

This works perfect on the development machine.

Every other machine I move it to produced the errors on the Pics I have attached. All of these machines have access 2007.

Pic 1= The macro as built by Access
Pic 2= The first error message afterupdate on the combo.
Pic 3=Details of error.

The database on every machine is in a trusted folder with sub folders included in the trust. I also on one machine gave full control on security to Everyone because of one post I read. Neither works.

I would really like to convert this to VBA but I need some help with the functions. My VBA skills are moderate. I have looked at docmd.findrecord and others but can't put it all together in vba.

Any thoughts

Phred

[Phred]

I solved the problem. I had an addin installed in my Access "Smart Indenter."

Under VB I selected Tools -> References -> SmartIndenter and the reference to the addin was marked as "Missing".

I cleared the check box and everything works fine.

No problem with the combo on any machine. I am guessing this would not have happened if I had compiled.

[Phred]

How do I mark this Solved?

[RuralGuy]

How do I mark this Solved?

It is under Thread Tools at the top of the thread. BTW...Access will compile automatically when you try and run the forms.