C
Can
I get this error when I open a form with a subform
"The column prefix ‘dbo.Day’ does not match with a table name or alias name
used in the query." and the spot for the subform is white
The table name is Day, the Link Child field and Link Master field is a field
called Day_New_CVAD_ID. The subform appears when I do not try to sort it but
when I sort on the field Day_CVAD_Date (Alias:CVAD_Date) in descending order
I get the error message above. When I open the subform alone the sorting
works and I don't get the error message. The only difference is putting in
Descending for the date, and the sort order of 1.
Any thoughts on what I am doing wrong? I am using Access 2000.
"The column prefix ‘dbo.Day’ does not match with a table name or alias name
used in the query." and the spot for the subform is white
The table name is Day, the Link Child field and Link Master field is a field
called Day_New_CVAD_ID. The subform appears when I do not try to sort it but
when I sort on the field Day_CVAD_Date (Alias:CVAD_Date) in descending order
I get the error message above. When I open the subform alone the sorting
works and I don't get the error message. The only difference is putting in
Descending for the date, and the sort order of 1.
Any thoughts on what I am doing wrong? I am using Access 2000.