C
Charles
Hello there
was wondering if someone could help me with a little problem. I have a
form with a bunch of List boxes that I want to populate through an sql
query through VBA.
My problem is the following: the sql query is as simple as it gets:
SELECT * FROM tblname WHERE tblname.Fld2=0;
where Fld2 is defined as an integer in the table tblname.
I invariably get a "Enter Parameter Value" for Fld2 when I load the
form and VBA does its work. I understand this is due to filters, i.e.
Access ignores whatever value I set in the WHERE statement and tries
to link it to some other value in the form. Is there any way to turn
that off and to let me define my forms manually?
It looks simple but I can't find the answer on google.
Thanks in advance for any help!
Charles
was wondering if someone could help me with a little problem. I have a
form with a bunch of List boxes that I want to populate through an sql
query through VBA.
My problem is the following: the sql query is as simple as it gets:
SELECT * FROM tblname WHERE tblname.Fld2=0;
where Fld2 is defined as an integer in the table tblname.
I invariably get a "Enter Parameter Value" for Fld2 when I load the
form and VBA does its work. I understand this is due to filters, i.e.
Access ignores whatever value I set in the WHERE statement and tries
to link it to some other value in the form. Is there any way to turn
that off and to let me define my forms manually?
It looks simple but I can't find the answer on google.
Thanks in advance for any help!
Charles