I have a table storing information about different drugs in inventory--number of unopened vials and amount in the one opened vial. The fields are named by the drug number and a "V" or "O" following designating full vials and volume remaining in the open vial. (1V, 1O, 2V, 2O, etc) I would like to add vials to the inventory through code and am having a hard time referring to the Field names in this table in my code. The variable I have assigned to the DrugID number from the Purchase form is "lngDrugID". I have tried rst.[lngDrugID & "V"], rst.["lngDrugID & 'V'"], etc. and get Error 3265 "Item not found in collection"
Any suggestions?
Bob
Any suggestions?
Bob