Multiple Select in List Box-Save to Table

[Maurita]

Hi, hope someone can help me with a problem I can't seem to work out.
I have a table called JOBS-Table where I created a list box with
employee names called lstEmployees, where the Multi Select option has
been changed to "Extended". The lstEmployees consists of three fields
from the table Employees, EmployeeNumber, LastName, and FirstName. I
have also created a table named INTERIM-Table to hold the Date and
Employee Name after selected from the JOBS-Form. I am having problems
getting the information saved into the INTERIM-Table from the
JOBS-Table, i.e. the Employee Name selected from the lstEmployees
listbox as well as the Date.

I appreciate any help that is given.

Thank you.

Maurita Searcy

 

[Van T. Dinh]

Which Field is the PrimaryKey Field(s) of your Table [Employees]?

You only need to store the PK Field value in the Table [INTERIM] as the FK
and that should be enough for you to determine the Employee's name.

Regarding multi-select ListBox (whose value is always Null) so you need to
write code to save the selections into the Table [INTERIM].

Search Google for lots of threads on how to save selections from a
multi-select ListBox. Here is one:

http://groups.google.com.au/group/microsoft.public.access.forms/browse_frm/thread/c350713dc7b9bce3