All,
I am struggling with a pretty simple issue. I have google-searched pretty thoroughly. While I have discovered solutions, they all contained VBA that was just beyond my ability to effectively manipulate.
I have intermediate Access skill, but only novice VBA ability. I am using Access 2010, 32 Bit.
I have a very simple database and I am trying to use an extended list box on a form to allow users to select multiple choices. And then click a command button that saves those choices to a record. I can get the list box to appear, and grant the capability to make multiple selections. But I am struggling to produce the VBA language necessary to translate those choices in a way that they can be saved to the record, and then subsequently saved.
I tried alternatives including an ill-advised lookup field, but no luck. Here is some additional information:
I’ve titled my listbox: lstEmployees
The row source is the EmployeeName field from the tblEmployees
The control source is the EmployeeName field in tblRecordsMaster which is also the table to which this form (frmEnterEmployee) is bound.
The basic idea is to allow the user to select several employees. And then to have to those employee names saved to the EmployeeName field in the appropriate record in tblRecordsMaster, preferable separated by commas.
Is this possible? And, if so, can you please help?
Thank you!