What's wrong in this formula

[Frank Situmorang]

Mike:

I should have replied to you instead of Mike Painter. Thanks very much Mike
for your suggestion. I already get tired after checking and checking nothing
wrong with the comma, etc. but when I put your suggestion it works now.

There are 2 things left that I have to think about on my churchdata base.

1. Making a dynamic report. the purpose of this is that we just need one
report to produce many fileter by member type, status, gender, churchname,
etc. Currently I have each report with each query ( filter in design query).
this method requires me to have many text labels to have to translated into
many languages, so I choose not to use this method.
2. Making append in the form menu. You have sent me the sample. I am just
studying it.

Thanks very much for all your helps.
--
H. Frank Situmorang

Dough:

On my Main Switchboard form I have the picuture of the church and the name
of the church. The form is based on this Query:
SELECT [Switchboard Items].SwitchboardID, [Switchboard Items].ItemNumber,
[Switchboard Items].Language, [Switchboard Items].ItemText, [Switchboard
Items].Command, [Switchboard Items].Argument, tblChurches.ChurchName_E,
tblChurches.ChurchName_L, tblChurches.CAddress1, tblChurches.CAddress2,
tblChurches.CpostalCode, tblChurches.CemailAddress, tblChurches.Cregion,
tblChurches.CCountry, tblChurches.Ccity, tblChurches.CPhone, tblChurches.CFax
FROM tblChurches INNER JOIN ([Switchboard Items] INNER JOIN tblDefaults ON
[Switchboard Items].Language = tblDefaults.Language) ON tblChurches.ChurchID
= tblDefaults.Church;

I have tried your suggestion, but still shows error message/syntax error

Please help.

Maybe what you need is a calculated field in the query.

IIF(tblDefaults.Language = "English" , tblchurches.ChurchName_E, tblChurches.ChurchName_L) AS
ChurchName

The control source on the form would then be ChurchName. If the default is English, ChurchName
will contain the churchname in English, otherwise it will contain the church name in the local
language.