Query based on Form

[B. J. Betts]

I am making a query based on a form.

My form MYSEARCH contains the following textbox

1. folderno
2. foldertitle
3. remarks

I tried placing a forms!mysearch!folderno in the criteria of the query .
Whether or not the value of the textbox is empty or not it does not return
any records... The form is active or open ... why is this so ..... Isn't it
suppose to get the value from the forms!mysearch!folderno???

Another question is what if there is no entry??? As of the moment ... with
or without an entry it does not return anything ... but if i remove it in
the criteria ... it returns all the records.

Please help

 

[Keith Wilby]

I am making a query based on a form.

My form MYSEARCH contains the following textbox

1. folderno
2. foldertitle
3. remarks

I tried placing a forms!mysearch!folderno in the criteria of the query .
Whether or not the value of the textbox is empty or not it does not return
any records... The form is active or open ... why is this so ..... Isn't
it suppose to get the value from the forms!mysearch!folderno???

Another question is what if there is no entry??? As of the moment ... with
or without an entry it does not return anything ... but if i remove it in
the criteria ... it returns all the records.

Please help

I've always found custom search forms to be a pain. Have you considered
using the built-in "filter by form" utility?

Regards,
Keith.
www.keithwilby.com

 

[AccessVandal via AccessMonster.com]

When you first open/run the form, the textboxes were blank or Null,
the records on the form was empty.

You'll need to place a command button to refresh the form's
record source once you input data into the textboxes.