batch Processing

G

Guest

Im working on an Access 2000 database. I need to create a form where I can
select multiple employees from a list or combo box that would create a
separate record for each employee selected. Is this possible? If so what is
the best way to go about doing this.
 
G

Guest

A combo box only allows one selection, so you will need to use a list box,
with the multiselect property set to either simple or extended. You then use
VBA code to determine which items have been selected. Helen Feddema has an
example on her web site:

Access Archon Columns from Woody's Office Watch
http://www.helenfeddema.com/access.htm

See tutorials:
71. Paired Single-Select Listboxes
72. Paired Multi-Select Listboxes

There is also a more featured example in the Access Developer's Handbook by
Litwin & Getz.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top