SQL syntax and functionality

Query...
PARAMETERS intID Short, intACHType Short, txtPlanNumber Text ( 255 ), curAmount Currency;
UPDATE tbl_ACH_Manual_Details SET tbl_ACH_Manual_Details.ACHType = [intACHType], tbl_ACH_Manual_Details.PlanNumber = [txtPlanNumber], tbl_ACH_Manual_Details.Amount = [curAmount], tbl_ACH_Manual_Details.[Date] = date()
WHERE (((tbl_ACH_Manual_Details.ID)=[intID]));

Before the above query runs the value for
tbl_ACH_Manual_Details.ACHType = 3
Which comes from a form cboType.Value

This table simply contains this data. ID is numeric and Type is Text.
tbl_lkpACHManual_Types...

ID    Type
1     Emergency
2     Domestic
3     International
4     N/A

Goal - We want the Type "International" to be retreived from tbl_lkpACHManual_Types table, which is the 3rd one. This 3 value comes from a form which has cboType.Value of 3

I believe the SET tbl_ACH_Manual_Details.ACHType = [intACHType], part of the query is what needs to be changed. How would I code this so that we get the value "International" in this case.

If cboType.Value is 1 then "Emergency" would be retreived
If cboType.Value is 2 then "Domestic" would be retreived
If cboType.Value is 3 then "International" would be retreived
If cboType.Value is 4 then "N/A" would be retreived

Thanks in advance