Auto Populating

A

ah

Hi;

I've a macro that could auto populate the data once I select the country
now. Can anyone guide me on how to add in the code to ask the form to reset
all the fields to empty before it auto populate the entry?


Below are the field auto populating code that I'm having now:

Dim oFld As FormFields
Set oFld = ActiveDocument.FormFields
Select Case oFld("Country_Name").Result


Case Is = "AUSTRALIA"
oFld("Allowance1").Result = "Car Allowance (IT14-6T01)"
oFld("Allowance2").Result = "Notional Salary Percentage (IT14-4T19)"
oFld("Allowance11").Result = "Hiring Bonus (IT15-1T07)"


'IT185
oFld("ID1").Result = "185-04 Work Permit"
oFld("ID2").Result = "185-10 Passport"
oFld("ID3").Result = "185-45 UID/MIN number- US Benefits ID"
oFld("ID4").Result = "185-50 USA Social Security Number"


'MISC Plan
oFld("ID1_Type").Result = "377 AUTR - AUSTRALIA TR PLAN"


Case Else
'Do nothing
End Select
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User Form question 1
Auto-populate form field 3
Auto-Populate Form Field 1

Top