"Syntax error in From clause" in new combo by wizard

[M Skabialka]

I created a form in Access 2000, based on a table. I wante to be able to
search for a record, so I used the add combo button wizrd.

I select Find a record on the my form based on the value selected in my
combo box, Next.
Selected the four field I want to show in the combo. Next.
At this point I get a message "Syntax error in From clause", OK

I can only Cancel/ A combo box is there but has not source or event
properties.

I tried compact and repair, but it isn't fixed.

What is causing this? How do I fix it?

Miche

 

[Sharkbyte]

Can you post the code behind the OnClick event? This should provide some
needed information.

Sharkbyte

 

[M Skabialka]

Seems that I renamed the combos and disaasociated the code from the button.
All is well now!

Thanks
Mich