Select some or show all records

[Samulayo]

I have a message box appear for users to enter the data required in order to filter a form, just the standard query message box.
Now a user would like to be able to see all the records in the list, as well as being able to select a certain range. What is required to be entered into the message box?
I know that typing "Is Not Null" in the criteria field achieves this result, but is not emulated when typing into the text box.

Regards
Samulayo

 

[dodge20]

How about *

Dodge20

 

[mpastore]

What data type is the criteria field?

Mike Pastore

Hats off to (Roy) Harper

 

[Samulayo]

the field is a string, i can now get this to work using the message box and the criteria

"Like [Forms]![Report Maker]![txtname]"

and then using * in the box, but i was auto filling the msgbox with data from a form (a filter form), where the use of * doesnt work, using a wherecondition:-

DoCmd.OpenReport stDocName, acPreview, stDocName, WhereCondition:="Discipline = [Forms]![Report Maker]![Discipline] And FullName = [Forms]![Report Maker]![txtname]"

 

[Samulayo]

and now it wants to work. wierd, thanks for the help anyway.

Regards
Samulayo