Filter by Form Problem

[a.j. scarbrough]

I have a form that has one subform on it. the main form has a 1 to m
relationship with the values in the subform. i have linked to two
forms using the linkmaster and linkchild properties of the subform.
the records are displayed in the form and subform without issue. if i
try to do a filter by form on the main form i receive the following
error message.

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

What am i doing wrong?? I have been unable to find an answer to this
anywhere on the www.

thanks.

 

[Guest]

This issue is related to the field in which the cursor is
currently located on when you active filter by form. make
sure you set in code that the cursor is in the proper
field (ie the id field in which you have the relationship)
and it should be fine.

Best Regards,
Ray Bell
SiemensWestinghouse Power Corp.

 

[aj scarbrough]

Placing the cursor in different fields before applying the filter by form
seems to have no impact. As a side note, this is an adp connected to a sql
server database. can anyone help with this issue???