Form to check if item used

[Mary]

My users would like a form with a checkbox to indicate whether a particular
system was accessed as part of working a ticket. The initial setup had them
selecting the systems they accessed from a dropdown. When they selected one,
a new row would allow them to select another, and so on. They would prefer
to see the complete list of approx 20 systems with a checkbox next to each.
Is this do-able? The systems are in one table, the form I designed is
related and is called the s_log. The s_log has a dropdown for the system
name and an EventID that updates automatically based on the Event they're
updating.

Please help.
Thanks!
Mary

 

[Mr. B]

Mary,

It is certainly do-able. However, I would suggest that you replace the
dropdown list (combo box) with a List box. You can show all posibilities in
the list box. If you set the Multi Select property of the list box to Simple
your users will be able to select multiple items in the list box.

You will need code to process the selections made by the user from the list
box.

There are plenty of postings here (just do a search) about processing
multiple selections from a list box that should help you with the code.

Here are a couple of links to knowledge base articles that might help:
http://support.microsoft.com/kb/135546
http://support.microsoft.com/kb/827423

Here is some help from Allen Browne's web site:
http://allenbrowne.com/ser-50.html

If you still need help, just post back here and we will be glad to help.

Good luck with your project.