Crystal, VB Formula help

[B1naryPro]

I have a visual basic front end with a check box, and when that user checks it, it goes out to the sql database and puts an "x" in that field. if that check box is checked i want all associated records to be shown in the report. So for instance i want to have 7 other fields shown in the report if that check box is checked(equal to "x&quot, but if it's not then i don't want to see it.

fldFirstName FldLastName fldCheck
J Smith x

no record no record no check

thanks for the help

JPBinary
MCSE, MCSA

 

[lbass]

I think you could try in your record selection:

{table.fldCheck} = "x"

Or, alternatively, you could try:

Not isnull({table.fldCheck})

-LB