Hello,
I do not understand why sometimes when using the combo box wizard for "find a record on my form based on the value I selected on my combo box", when I start selecting the fields and then select next, I get this window message "syntax error in query expression '[SELECT * FROM "table" ORDER BY ["TABLE"]].[["PRIMARY KEY-FIELD]'.
"TABLE"-refers to the table that form is created for
"PRIMARY KEY-FIELD"-is the field that I have selected as my primary key.
There are sometimes when the lookup boxes for other forms work fine. Can somebody explain to me what I am possibly doing wrong?
Thanks,
I do not understand why sometimes when using the combo box wizard for "find a record on my form based on the value I selected on my combo box", when I start selecting the fields and then select next, I get this window message "syntax error in query expression '[SELECT * FROM "table" ORDER BY ["TABLE"]].[["PRIMARY KEY-FIELD]'.
"TABLE"-refers to the table that form is created for
"PRIMARY KEY-FIELD"-is the field that I have selected as my primary key.
There are sometimes when the lookup boxes for other forms work fine. Can somebody explain to me what I am possibly doing wrong?
Thanks,
