Thanks Tom for your reply, I plan to use this just for Switchboard Menut
Items. and chruch table. For the reports and form I already use VBA on each
caption label of the forms and reports.
Is it also slow, even though for churchtable and just English and Local,
then I put it on the different back End, so I changed the linked for every
different country.
Thanks
--
H. Frank Situmorang
"Tom van Stiphout" wrote:
[Quoted Text] > On Mon, 1 Dec 2008 18:55:01 -0800, Frank Situmorang
> <hfsitumo2001[ at ]yahoo.com> wrote:
>
> The ControlSource should be:
> =IIf(DLookUp("Language","Defaults")="English",[ChurchNameE],[ChurchNameL])
>
> Note: if you do this for a lot of fields, your app will be very slow.
> Alternatives require some VBA, which IIRC you don't master yet.
>
> -Tom.
> Microsoft Access MVP
>
>
> >Hello,
> >
> >In my Churches table I have chruch ID and ChruchnameE for English Name and
> >ChurchNameL for Church Local Name.
> >
> >What should should mention on the textcontrol to say if language in Defaults
> >table is not English, then it will take the Local Name.
> >
> >Anyone can help me please?
> >
> >Thanks in advance
>
|