Selecting more than one option

[Nick Pedder]

Hi,

I have a subform which is based on a query. I need to allow the user to
select more than one option in the numerous 'value lists' contained within on
the subform.

How would I go about achieving this?

Any help would be greatly appreciated.

Thanks,

Nick

 

[Jeff Boyce]

Nick

What's the query's SQL? How have you implemented "value lists" on the
subform? What is it that you are trying to accomplish?

 

[Nick Pedder]

Thanks for your speedy response Jeff.

I'm no expert on access, but....

The SQL for the query which displays the subform is:

SELECT tblProcedures.NINumber, tblProcedures.InformalDateFrom,
tblProcedures.InformalDateTo, tblProcedures.InformalStage,
tblProcedures.InformalProcedure, tblProcedures.InformalActions,
tblProcedures.InformalProcedureOutcome, tblProcedures.FormalDateFrom,
tblProcedures.FormalDateTo, tblProcedures.FormalStage,
tblProcedures.FormalProcedure, tblProcedures.FormalActions,
tblProcedures.FormalProcedureOutcome, tblProcedures.DateOfHearing,
tblProcedures.HearingOutcome, tblProcedures.DateOfAppeal,
tblProcedures.AppealOutcome, tblProcedures.Notes, tblProcedures.Completed,
tblProcedures.AdvisorsName, tblProcedures.EmploymentTribunalDate,
tblProcedures.EmploymentTribunalOutcome
FROM tblProcedures;
, tblCandidateDetails.Directorate, tblCandidateDetails.[Ward/Dept]
FROM tblCandidateDetails
WHERE (((tblCandidateDetails.NINumber)=[Please enter NI Number]));


As far as I am aware the value lists are implemented in the subform - in the
properties, the 'row source type' is selected as value list.

To briefly explain, I'm designing the database as a method of recording HR
procedures for the HR staff to record for staff in our organisation. For
each member of staff, a number of different procedures under different
categorie may apply to them. These are all recorded in the subform
'Subform2newrecord'. For example, one category is informal procedures. For
this category, I need to able to record whether the procedure is one or more
of these :

"ST Capability Sickness";"LT Capability Sickness";"Capability
Performance";"Disiplinary";"Grievance";"Bullying and Harasment";"Harassment"

The database is set fine to just record one option, but I can't figure out
how to select more than one option in the drop down box.

Thanks again for your help.

Nick.

 

[Jeff Boyce]

Nick

I may not be following fully, but it sounds like you have a 1:M
relationship. Have you considered using a sub-form to hold the "M" side
items?

Jeff Boyce
<Access MVP>

Thanks for your speedy response Jeff.

I'm no expert on access, but....

The SQL for the query which displays the subform is:

SELECT tblProcedures.NINumber, tblProcedures.InformalDateFrom,
tblProcedures.InformalDateTo, tblProcedures.InformalStage,
tblProcedures.InformalProcedure, tblProcedures.InformalActions,
tblProcedures.InformalProcedureOutcome, tblProcedures.FormalDateFrom,
tblProcedures.FormalDateTo, tblProcedures.FormalStage,
tblProcedures.FormalProcedure, tblProcedures.FormalActions,
tblProcedures.FormalProcedureOutcome, tblProcedures.DateOfHearing,
tblProcedures.HearingOutcome, tblProcedures.DateOfAppeal,
tblProcedures.AppealOutcome, tblProcedures.Notes, tblProcedures.Completed,
tblProcedures.AdvisorsName, tblProcedures.EmploymentTribunalDate,
tblProcedures.EmploymentTribunalOutcome
FROM tblProcedures;
, tblCandidateDetails.Directorate, tblCandidateDetails.[Ward/Dept]
FROM tblCandidateDetails
WHERE (((tblCandidateDetails.NINumber)=[Please enter NI Number]));


As far as I am aware the value lists are implemented in the subform - in the
properties, the 'row source type' is selected as value list.

To briefly explain, I'm designing the database as a method of recording HR
procedures for the HR staff to record for staff in our organisation. For
each member of staff, a number of different procedures under different
categorie may apply to them. These are all recorded in the subform
'Subform2newrecord'. For example, one category is informal procedures. For
this category, I need to able to record whether the procedure is one or more
of these :

"ST Capability Sickness";"LT Capability Sickness";"Capability
Performance";"Disiplinary";"Grievance";"Bullying and Harasment";"Harassment"

The database is set fine to just record one option, but I can't figure out
how to select more than one option in the drop down box.

Thanks again for your help.

Nick.

Nick

What's the query's SQL? How have you implemented "value lists" on the
subform? What is it that you are trying to accomplish?

--
More info, please ...

Jeff Boyce
<Access MVP>

within
on

 

[Nick Pedder]

Hi Jeff,

Yes, I am using a 1:M relationship in that for every one member of staff
there may be many sets of procedures that apply for them. For example, if a
member of staff gets caught stealing from the premises, they may have to go
through a number of procedures - Informal - formal - a hearing - an appeal
and finally a tribunal, for that one 'incident' All these are contained on
the one subform.

In a situation where this member of staff remains, and they commit another
'offence', the same procedures could be recorded all over again.

The subform can therefore be 'flicked' through to diplay all the different
cases of any 'incidents' which they are involved in.

However, within the subform, each procedure (e.g. informal) also has an
outcome, which is selected from a value list. I can only select one outcome
(e.g. investigation) though. The problem is, is that for some situations, a
second outcome would have to be recorded.

I suppose I could have two value lists for each value list that I need to be
able select two options for, (e.g. Outcome 1 and Outcome 2), but this would
be clumsy and it'd be good if there was any way round it.

Sorry if this has become slightly long-winded! I hope this makes more sense.

Thanks,

Nick

Nick

I may not be following fully, but it sounds like you have a 1:M
relationship. Have you considered using a sub-form to hold the "M" side
items?

Jeff Boyce
<Access MVP>

Thanks for your speedy response Jeff.

I'm no expert on access, but....

The SQL for the query which displays the subform is:

SELECT tblProcedures.NINumber, tblProcedures.InformalDateFrom,
tblProcedures.InformalDateTo, tblProcedures.InformalStage,
tblProcedures.InformalProcedure, tblProcedures.InformalActions,
tblProcedures.InformalProcedureOutcome, tblProcedures.FormalDateFrom,
tblProcedures.FormalDateTo, tblProcedures.FormalStage,
tblProcedures.FormalProcedure, tblProcedures.FormalActions,
tblProcedures.FormalProcedureOutcome, tblProcedures.DateOfHearing,
tblProcedures.HearingOutcome, tblProcedures.DateOfAppeal,
tblProcedures.AppealOutcome, tblProcedures.Notes, tblProcedures.Completed,
tblProcedures.AdvisorsName, tblProcedures.EmploymentTribunalDate,
tblProcedures.EmploymentTribunalOutcome
FROM tblProcedures;
, tblCandidateDetails.Directorate, tblCandidateDetails.[Ward/Dept]
FROM tblCandidateDetails
WHERE (((tblCandidateDetails.NINumber)=[Please enter NI Number]));


As far as I am aware the value lists are implemented in the subform - in the
properties, the 'row source type' is selected as value list.

To briefly explain, I'm designing the database as a method of recording HR
procedures for the HR staff to record for staff in our organisation. For
each member of staff, a number of different procedures under different
categorie may apply to them. These are all recorded in the subform
'Subform2newrecord'. For example, one category is informal procedures. For
this category, I need to able to record whether the procedure is one or more
of these :

"ST Capability Sickness";"LT Capability Sickness";"Capability
Performance";"Disiplinary";"Grievance";"Bullying and Harasment";"Harassment"

The database is set fine to just record one option, but I can't figure out
how to select more than one option in the drop down box.

Thanks again for your help.

Nick.

Nick

What's the query's SQL? How have you implemented "value lists" on the
subform? What is it that you are trying to accomplish?

--
More info, please ...

Jeff Boyce
<Access MVP>

Hi,

I have a subform which is based on a query. I need to allow the user to
select more than one option in the numerous 'value lists' contained within
on
the subform.

How would I go about achieving this?

Any help would be greatly appreciated.

Thanks,

Nick

 

[Jeff Boyce]

Nick

Let me see if I can paraphrase -- correct my misunderstandings...

One staff member can have zero, one, or many procedures.

Each StaffMember/Procedure combination can have one or more Outcomes.

If this fairly describes your situation, you have a 1:M:M relationship, in
which Staff to Procedure is 1:M, and Procedure to Outcome is 1:M.

You can store the data this way, and use "nested" subforms to drill all the
way down.

Since a procedure could be applied to a StaffMember a second time, you'd
need to have the StaffMember/Procedure table include a DateOfProcedure
field, so you could tell the incidents apart.

Ditto for the StaffMember/Procedure/Outcome table (a DateOfOutcome), to tell
when an outcome applied to a procedure that applied to a Staff Member.


--
Good luck

Jeff Boyce
<Access MVP>

Hi Jeff,

Yes, I am using a 1:M relationship in that for every one member of staff
there may be many sets of procedures that apply for them. For example, if a
member of staff gets caught stealing from the premises, they may have to go
through a number of procedures - Informal - formal - a hearing - an appeal
and finally a tribunal, for that one 'incident' All these are contained on
the one subform.

In a situation where this member of staff remains, and they commit another
'offence', the same procedures could be recorded all over again.

The subform can therefore be 'flicked' through to diplay all the different
cases of any 'incidents' which they are involved in.

However, within the subform, each procedure (e.g. informal) also has an
outcome, which is selected from a value list. I can only select one outcome
(e.g. investigation) though. The problem is, is that for some situations, a
second outcome would have to be recorded.

I suppose I could have two value lists for each value list that I need to be
able select two options for, (e.g. Outcome 1 and Outcome 2), but this would
be clumsy and it'd be good if there was any way round it.

Sorry if this has become slightly long-winded! I hope this makes more sense.

Thanks,

Nick

Nick

I may not be following fully, but it sounds like you have a 1:M
relationship. Have you considered using a sub-form to hold the "M" side
items?

Jeff Boyce
<Access MVP>

Thanks for your speedy response Jeff.

I'm no expert on access, but....

The SQL for the query which displays the subform is:

SELECT tblProcedures.NINumber, tblProcedures.InformalDateFrom,
tblProcedures.InformalDateTo, tblProcedures.InformalStage,
tblProcedures.InformalProcedure, tblProcedures.InformalActions,
tblProcedures.InformalProcedureOutcome, tblProcedures.FormalDateFrom,
tblProcedures.FormalDateTo, tblProcedures.FormalStage,
tblProcedures.FormalProcedure, tblProcedures.FormalActions,
tblProcedures.FormalProcedureOutcome, tblProcedures.DateOfHearing,
tblProcedures.HearingOutcome, tblProcedures.DateOfAppeal,
tblProcedures.AppealOutcome, tblProcedures.Notes, tblProcedures.Completed,
tblProcedures.AdvisorsName, tblProcedures.EmploymentTribunalDate,
tblProcedures.EmploymentTribunalOutcome
FROM tblProcedures;
, tblCandidateDetails.Directorate, tblCandidateDetails.[Ward/Dept]
FROM tblCandidateDetails
WHERE (((tblCandidateDetails.NINumber)=[Please enter NI Number]));


As far as I am aware the value lists are implemented in the subform -

in
the

properties, the 'row source type' is selected as value list.

To briefly explain, I'm designing the database as a method of recording HR
procedures for the HR staff to record for staff in our organisation. For
each member of staff, a number of different procedures under different
categorie may apply to them. These are all recorded in the subform
'Subform2newrecord'. For example, one category is informal procedures. For
this category, I need to able to record whether the procedure is one

or
more

of these :

"ST Capability Sickness";"LT Capability Sickness";"Capability
Performance";"Disiplinary";"Grievance";"Bullying and Harasment";"Harassment"

The database is set fine to just record one option, but I can't figure out
how to select more than one option in the drop down box.

Thanks again for your help.

Nick.


:

Nick

What's the query's SQL? How have you implemented "value lists" on the
subform? What is it that you are trying to accomplish?

--
More info, please ...

Jeff Boyce
<Access MVP>

Hi,

I have a subform which is based on a query. I need to allow the

user
to

select more than one option in the numerous 'value lists'

contained
within

on
the subform.

How would I go about achieving this?

Any help would be greatly appreciated.

Thanks,

Nick