Can I open the source record stored in a Multiple value Combo box field, Access 2007

[TechyGal]

Hi there!

I pose another question in the hope of finding someone who can advise
me on a possible solution!!??

I have developed an Access database for logging and monitoring IT
Support Issues and would like to be able to perform the following task
on an Access 2007 form:

1). I have created a form where the users and IT team can enter all
the information that relates to an individual IT issue.

On this form there is a tab title 'Related Cases' this is a number
field in the table 'Cases' and is set to Long Integer with the display
control selected as 'Combo Box' this field uses a Query to identify
what cases have been chosen to be Related to this specific case. The
field 'Related Cases' is also set to allow Multiple values to be
selected because there could be the need to relate more that one case.

Currently on the 'Case Details' form the user can only see the title
of the related cases in the List Box!

I would like the user to be able to double-click on the title to then
launch/open this record into a new window - In theory a bit like a
Hyperlink!

Is this possible?? I seem to get error messages relating to the fact
that the field allows multiple values!

Is there any way of getting around this??

Any help or advice would be greatly appreciated!!

From a novice in the database field but a very keen and enthusiastic

learner!!

TechyGal

 

[Arvin Meyer [MVP]]

Multiple value fields were designed to enable Access to work with
SharePoint, which is a flat file list viewer, but can use data from
relational databases. If SharePoint is not in your design specs, I'd advise
never using multi-value fields because they add a complexity that's
difficult and unnecessary to program for.

 

[TechyGal]

Hi Arvin,

Are you saying that it is not possible to link to the source of the
value shown in the combo box?

I am not using Sharepoint and I know this (multi values) is a new
feature within Access 2007 but I am happy to try and add some VB code
if pointed or rather guided (step-by-step) by someone who already has
the kowledge!! Unlike myself who is just starting up. A wee little
seed of a database developer one might say! Just need to be watered
a little and I will surely grow!

With Thanks From

TechyGal