You shouldn't use an = sign for NULLS. NULL does not equal NULL. Something that is undetermined cannot equal something else that is undetermined.
Best to use
IF ISNULL(field)
BLANK Field
ELSE
Thisform.refresh
ENDIF
>VFP 3.0
>
>Hello All,
>
>I have a weird one here folks....ok here goes
>
>I have a browse form...when the form opens it searches the dbf for
>a number, locates the record, then continues to search the dbf for
>another field that is a character field, once it is located the record
>displays and everyone signs happy happy joy joy.
>
>The problem is the second field, when the value is .null the dbf displays
>the wrong record.
>
>I know i have to do something about the null and have tried to no avail.
>
>any thoughts? I am thinking something like this..
>
>IF field=.null.
>BLANK field
>ELSE
>THISFORM.REFRESH
>
>Thanks and have a good day.
>
>Becky
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only