Hi, I am using access 07. I have created an input form (forms.Base) with an input field of source_code. Below this there are options for other fields to be updated in a record set. There would be multiple entries in the source_code field, seperated by ';'. There would be a maximum number of 10 entries in this field. When the user presses submit, the table (tbl.base) would be updated with the entry in the source_code field, with each of the values inserted in the other entry fields. It would then loop until there are no more entries in the source_code field. Therefore in the dataset/table the source_code field would be populated with each different value but the other fields would be populated with the same values. Can anyone help with the required VBA code? Thanks
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!