multi select for updating a table.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The web sites have been helpful in explaining how I can ue the multi select
box for viewing existing information. How can I imput the data into a table.

I need to be able to select an Application User on my form and select one or
many applications (out of 150) that they use in order to maintain what
applications everyone in my company is using.

Can you direct me to a good web site that explains how to use a form that
uses the selections to update a table.
 
Can I just check what you currently have?

A table of application users, a table of applications, and a table of
application users. And a many to many relationship from users to
applications with the application users table as the junction table.

Correct?
 
Hi Sharon

I assume you have written code to mark the selected applications by reading
the records in your join table when a given user's record is displayed.

In the same way, you must write code to go through all the list items and,
if selected, add a record to the table (if one does not exist) otherwise
delete the corresponding record if it does exist.

Perhaps if you post the code you are using to preload the listbox
selections, it would be easier to tell you what to do next.
 
Yes,
tblApplicationUsers
tblApplicationsList
tblJunctionApplicationsAssignedToUsers

The code I have now, (by Allen Browne), allows me to choose one or many
applications for a user and then shows it in a report by choosing a preview
button. How can I get that code to write my selections to a table?
 
Could you post that code please. That'll probably be easier than starting
again from scratch.
 
Back
Top