Hi guys & girls, Thank you in advance for your help.

I have a form based on two tables. When I open this form I get a syntax [From] error.

Thanks
Joe

Open the form in design view and check its rowsource for coirrect context.

Alternatively, create an On-Open event in case you don't have one and set a breakpoint on the subrouinte line (F9). Open the form and single step through your code (repeated hit F8) to see where the your code errors.