Modifying a subform in 2007 cause a data source error

[NeeNee]

I have an Access project created in 2003 but now converted to 2007. I have a subform which has a query as record source. This query only joins 2 tables. I am required to add a new field to the query and the sub form, but as soon as I switch to form mode, I get the following error;

"The column prefix 'dbo.Expend' does not match with a table name or alias name used in the query".

Now I know this means that it does not recognize the table name in the query, but the query works fine in the query designer. If I remove the changes, the subform is still defective and the error won't go away. when this first happened, I had to get a copy of the database from our backup tape.

Now I have a second sub form with only 1 table as record source and when I changed it, I did not get this problem. This seams to be caused by the query joining 2 tables.

I am at a loss. I just want to add 1 field to the query and the form. This must be a 2007 problem, because I never had this kind of problems in 2003.

Any suggestions would be appreciated.

Thanks


Denis
Programmer, Canada

 

[TheAceMan1]

How are ya NeeNee . . .

Post the [blue]SQL[/blue] of the query!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]