I need a code to show the correct time in a text box based
on the time zone a record is in. The base time would be
Central and I need it to show the correct current time
based on the state listed in my state text box. Does
anyone have a working code to do that?

See whether the code Randy Birch has at
http://www.mvps.org/vbnet/code/local...mezonebias.htm helps.

(Note: you sometimes need to be careful with code from Randy's site, as it's
aimed at VB programmers. That means that sometimes the instructions for
forms won't work in Access, because of the differences in how form controls
work between the two. Looking quickly at this particular page, though, I
think it'll work in Access without any problems.)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele


"JHumbert" <(E-Mail Removed)> wrote in message
news:2a5d01c37961$045ba790$(E-Mail Removed)...
> I need a code to show the correct time in a text box based
> on the time zone a record is in. The base time would be
> Central and I need it to show the correct current time
> based on the state listed in my state text box. Does
> anyone have a working code to do that?