Having same problem still

[Someone Curious]

Hi all

I had some adivce the other day, thanks but I am still having problems

I have a report that uses data from a query to populate.

I want turn on and off check boxes dependant on the data.

I have created sub routines that do this function correctly.

In the detail section I have set up an event on format

It goes like this...


if [My Query]![My Table].[FirstName] = "Fred" then
DoMySubRoutine
else
DoMyOtherSubRoutine
end if

this errors with a runtime error saying field | does not exist.

The error is in the first line although.

Any suggestions

TIA

 

[Graham R Seach]

If you're trying to do this from a report, check out Help for Conditional
Formatting.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia