Hello,
Very bizarre problem. We are using Access 2000 and our queries recently 'stopped working'. When we try to add a column to the query which references a form's control: Expr1: [Forms]![Form1]![txtName]--it works ONLY IF the value being returned is a String. If a date or number is in the form field the query returns a blank or some other strange character. FACTS: (1) The form IS based on a table. (2) We have attempted to set the format/field type of the query field. (3) Changing the default field type (under Options) has not helped. Solve this and we'll be thankful and recommend you.
Very bizarre problem. We are using Access 2000 and our queries recently 'stopped working'. When we try to add a column to the query which references a form's control: Expr1: [Forms]![Form1]![txtName]--it works ONLY IF the value being returned is a String. If a date or number is in the form field the query returns a blank or some other strange character. FACTS: (1) The form IS based on a table. (2) We have attempted to set the format/field type of the query field. (3) Changing the default field type (under Options) has not helped. Solve this and we'll be thankful and recommend you.