These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Need help with CALC City/State/Zip- Extreme noobie - Help

eagleowl
Registered: Dec 12 2008
Posts: 2

We want to streamline a form that we use often. It would save time for vendors and applicants if we could include an auto-fill for city and state based on a Zip code entry. Our city/state/zip source is an MS Access 2003 file. What calculation would I use to do this? Can anyone point me in the right direction?

I have used LiveCycle to create basic forms for email correspondance. I work in finance & purchasing so I use MS Office a lot, therefore, I'm used to
functions and formulas in Excel.

WHERE ARE MY IF & VLOOKUP functions???

My Product Information:
LiveCycle Designer, Windows
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4308
Have you looked at the "DataConnection" of LiveCycle Designer?

You will have to use some SQL statements to retrieve the data from the Access table.

George Kaiser