Hi Guys

I have a dataentry form based on a view

some of the fields of my view are lookups into other tables.

there are going to be cases where the user will not want to fill in

all the information on the dataentry form.

If this is so, then the next time I go to display the form I would expect

to see the data that I just entered, but because of my filter, I won't see

the data.

I tried to take care of this by adding the following lines to my filter

Table.cMyField LIKE "%"
Table.cMyField = ""

So now the filter of the view will look somehting like the following in the view designer:

Field Name NOT Criteria Example Case Logic
.
.
.
.
. AND
Table.cMyField = OtherTable.cOtherTable OR
Table.cMyField LIKE "%" OR
Table.cMyField = ""

When I run the view, I would expect to see some records in the browse window where cMyField is Blank or Empty, but I don't!

What can I do to solve this

Thank You

Gary Hagerty