Transferring Data Selected from a List Box on a Subform

[klipfer]

I don't know a whole lot about Access, but I'm running into a big problem. I
have a subform displayed in datasheet view. In the on entry property of the
text box "Jump Type" I can successfully open a small pop up form with a list
box and an OK button. Additionally, I have set the list box properties to
allow multiple selections. This list box is populated from a table that has
several fields: "Code," "Jump Type," and "Jump Type ID"; although "Jump Type
is the only text displayed in the list box. What I'd like to do is to make
multiple selections from the list box and when I click my OK button, the
Codes corresponding to the Jump Types will be displayed in the text box on
the subform in datasheet view. How do I get the pop up form to capture the
data I selected and insert the corresponding code into the appropriate text
box on the subform?

Here is a sample of the underlying table that populates the list box:

CODE JUMP TYPE ID
A Administrative 1
C Combat 2
CE Combat Equipment 3
J Jumpmaster 4
MT Mass Tactical 5
N Night 6
NT Non-Tactical 7
T Tactical 8

Remember, the only data displayed in the list box is the "Jump Type" field
text. If I wanted to select "Administrative," "Combat Equipment," and
"Non-Tactical" how would I get the corresponding codes to display in the text
box of my subform in datasheet view? And, how can I insert a seperator, with
a space on each side, in between each code? Ideally, based upon the 3
selections I just mentioned, I'd like the data to display in the text box as
follows: "A / CE / NT" Any suggestions?

I've been stuck at this point for months, just trying different things to
get it to work and without success. Any help anyone can give me is greatly
appreciated in advance.

Sincerely,

JT Klipfer

 

[Jonathan Parminter]

-----Original Message-----
I don't know a whole lot about Access, but I'm running into a big problem. I
have a subform displayed in datasheet view. In the on entry property of the
text box "Jump Type" I can successfully open a small pop up form with a list
box and an OK button. Additionally, I have set the list box properties to
allow multiple selections. This list box is populated from a table that has
several fields: "Code," "Jump Type," and "Jump Type ID"; although "Jump Type
is the only text displayed in the list box. What I'd like to do is to make
multiple selections from the list box and when I click my OK button, the
Codes corresponding to the Jump Types will be displayed in the text box on
the subform in datasheet view. How do I get the pop up form to capture the
data I selected and insert the corresponding code into the appropriate text
box on the subform?

Here is a sample of the underlying table that populates the list box:

CODE JUMP TYPE ID
A Administrative 1
C Combat 2
CE Combat Equipment 3
J Jumpmaster 4
MT Mass Tactical 5
N Night 6
NT Non-Tactical 7
T Tactical 8

Remember, the only data displayed in the list box is the "Jump Type" field
text. If I wanted to select "Administrative," "Combat Equipment," and
"Non-Tactical" how would I get the corresponding codes to display in the text
box of my subform in datasheet view? And, how can I insert a seperator, with
a space on each side, in between each code? Ideally, based upon the 3
selections I just mentioned, I'd like the data to display in the text box as
follows: "A / CE / NT" Any suggestions?

I've been stuck at this point for months, just trying different things to
get it to work and without success. Any help anyone can give me is greatly
appreciated in advance.

Sincerely,

JT Klipfer
.

Hi use online help to lookup "selected property"

the example given should help

Luck
Jonathan