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()
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.
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