I have a simple bit of code which I use to force various entrys in specific fields after a trigger event...
I would like to use a drop down list of set values other than an input box which doesnt offer the user any choice (See last line of the code below)......any ideas??
If Me.Transaction_Type = "Repair" Then
Me.Part_No = "TOOL-REPAIR"
Me.Supplier = "00000"
Me.Stock_Status = "N/A"
Me.Qty_Req = "1"
Me.Work_Description = InputBox("Enter description of the Tool Repair")
Me.Work_Supplier = InputBox("Enter Supplier Code")