Creating an option group that allows you to select more than one?

[Guest]

I look after students trying to get a job and send their CV's to employers.
We have a form that allows us to see which areas of business (e.g finance,
marketing etc) and what part of the country they want to work in (e.g north
west, south west etc.) I want to be able to select more than one option for
both the area of business and the region. Hopefully enabling me create a
query that will ask which region and which area of business. Will I have to
change the table that this information comes from without having to produce
multiples queries. My version is 2003. I hope this is clear. Many thanks.

 

[Arvin Meyer [MVP]]

On Option group will only allow 1 selection. You can use a multi-select list
box with an IN clause to select multiple choices for query criteria.

 

[Guest]

Sorry but I have no idea how to do that either, I've tried the help feature
but doesn't bring anything up. Any suggestions? Step- by- step guide would be
very much appreciated.

Laura

 

[Larry Linson]

Sorry but I have no idea how to do that either,
I've tried the help feature but doesn't bring anything
up. Any suggestions? Step-by-step guide would be
very much appreciated.

An option group ties together multiple Option Buttons, Toggle Buttons, or
Check Boxes so that they act together, checking one turning off all the
others, to yield a numeric result. However, you can place Option Buttons,
Toggle Buttons, or CheckBoxes individually on the Form, so that each will
have a True/False value. Perhaps this is what you need to consider.

Sometimes, problems are simple and clear enough that we can provide a
step-by-step solution. Other times, we have to suggest that some basic
self-study or other training would be a good idea. Frankly, I don't see
enough detail in your description that we can do other than give you a
direction, and suggest self-study. Then we can wait for you to try something
and come back with a specific error.

On the home page of http://office.microsoft.com, there are links to a number
of online training modules that you might find helpful. Microsoft Access
Step-by-Step from Microsoft Press is a good introductory self-study (be sure
to get the edition for the version of Access you are using. Microsoft Access
Inside-Out is an excellent book that goes deeper into Access use and
development. Both are from Microsoft Press.

Larry Linson
Microsoft Access MVP

 

[Arvin Meyer [MVP]]

Here's a code snippet using a multi-select ListBox named lstElevation:

Dim strList As String
Dim varItem As Variant

With Me!lstElevation
If .MultiSelect = 0 Then
Me!txtSelected = .Value
Else
For Each varItem In .ItemsSelected
strList = strList & .Column(0, varItem) & ","
Next varItem
If strList <> "" Then
strList = Left$(strList, Len(strList) - 1)
End If
Me.txtSelected = strList
End If

End With

txtSelected is a hidden textbox used to store the values for a
SQL-statement.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com