hey if i ahve a criteria in a query that draws a value from a form, if the value in the form is null shouldn't all the record show up in the query?
I made a query that has like 3 criteria. my form when i click a button would set the values in two combo box as null and a value in the other, it then opens a query that should show all records with the data that was entered in the field that was filled. When the query opens tho i don't see anything, does anyone know y? My relationships are fine and everything and all record show up in the query when i take out the relationships. it kinda sucks. can anyone help? thanks in advance.
chaosguy
Chaosguy - To die would be an awefully big adventure.
I made a query that has like 3 criteria. my form when i click a button would set the values in two combo box as null and a value in the other, it then opens a query that should show all records with the data that was entered in the field that was filled. When the query opens tho i don't see anything, does anyone know y? My relationships are fine and everything and all record show up in the query when i take out the relationships. it kinda sucks. can anyone help? thanks in advance.
chaosguy
Chaosguy - To die would be an awefully big adventure.