Dan, In your form variable definitions do something like this:
DateVar = Rough in yourTable where YourCriteria RoughVarForForm = (ifnull(.DateVar,Null,'X')) Ben Petersen On 12 Dec 2002, at 9:48, Dan Champion wrote: > > > 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/ > ================================================ 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/
