Hi all,
I'm new to Access programming so bear with me.

I have a report with a record source set to use a SQL Server view.

I recently changed the SQL Server view to include new fields added to one of the tables.

In the Access Report - Design View I can see the new fields that have been added. Even in the actual code I can get intellisense for the fields, ie. Me."field name" is showing up.

One of the new fields is an integer called ReferralReason.
I can do something like

If Me.ReferralReason = 0 then
Do something...
End If

When I run the report I get an error that says
can't fine the field 'ReferralReason' referred to in your expression

Why can I see and reference the fields in design view but not when I run the report? Do I need to "refresh?" the access db? If so, how do I do that?
Thanks.

ok you say that your sure that such a field is sure to be part of your report (would you double check please ? spelling and everything ?)
now , which section of the report you have your code running ? do notice that report's sections are privately referanced (i.e if your code is within a header / footer / custom group section or details section while that control isnt part of this section such error might occure)
that'd be all i'd suggest within the scope of given data