Hi, I have a query in my database that filter data from 2 tables with relationship
one to many between tables. I also have a form with text boxes for inputing data to the query.
In the query I have a criteria that takes input from my form. The code in query criteria field is
Between [forms]![frm_laikotarpis].[startdate] And [forms]![frm_laikotarpis].[enddate]
This filter my data by date.
In the other criteria field I want to show records that match the second filtering criteria.
This the query code
[forms]![frm_laikotarpis].[text_field_name]
Everything works until I decided that I still would like to be able to view all records without filtering.
In my form I enter "is not null" into the field that forwards data to my query and I get error that expression is typed incorrect or is too complex. If I enter "is not null" inside criteria field in my query directly is works fine so how to pass this "is not null" with textbox from a form???
P.S. I actually wanted to pass data from a drop down box, but since I don't know how to pass "is not null" decided to try to solve this with textbox.
Thank you.
one to many between tables. I also have a form with text boxes for inputing data to the query.
In the query I have a criteria that takes input from my form. The code in query criteria field is
Between [forms]![frm_laikotarpis].[startdate] And [forms]![frm_laikotarpis].[enddate]
This filter my data by date.
In the other criteria field I want to show records that match the second filtering criteria.
This the query code
[forms]![frm_laikotarpis].[text_field_name]
Everything works until I decided that I still would like to be able to view all records without filtering.
In my form I enter "is not null" into the field that forwards data to my query and I get error that expression is typed incorrect or is too complex. If I enter "is not null" inside criteria field in my query directly is works fine so how to pass this "is not null" with textbox from a form???
P.S. I actually wanted to pass data from a drop down box, but since I don't know how to pass "is not null" decided to try to solve this with textbox.
Thank you.
Last edited: