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
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