"if succeeds"

[Dan Champion]

Hi,
I am looking for the equivalant of the "if fails use default" option you get when placing a column on a form. Presently if you place a column on a form, you get a popup asking what to use if the lookup fails. You can set a default value.
I would like to be able to set a default value if the lookup succeeds. Instead of showing the data found in the column.

IE

the feilds below are date fields, but all I want to know is if the fields have data in the table or not. I don't want the dates to show, just a simple X to show that they have data.


Inspections:
Rough, Underground, Ductwork, Final
X X

Is there a way to do this?

Thanks


Dan Champion
P.O. Box 223
Grandville, MI. 49428-0223
www.championsolutions.net


================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/