RowSource Dilemna

[Guest]

Hi All...

I have a form that has several combo boxes and list boxes on it.

I jump through a few hoops to geth there but what I end up with is a list
box containing a value list that is passed using vba. Once all the values are
placed into this list I save the rowsource of that list to a text field in a
table.

Here's my dilemna, how do I then take the data from that text field and
re-display it as the value list for a list box?

I've looked out here for a similar situation and found none so... When all
else fails, ask the experts...

Thanks again,

m

 

[Guest]

so, you are concatenating all the rows in a list box into one field in one
row of a table? I don't think I get the point of doing that. I'm sure I
must misunderstand. Please clarify, and maybe we can find a solution.

 

[Guest]

Yes, I'll try to clarify...

I have a combo that holds resource types like Mainframe Developer or Web
Developer. Once the user selects the resource type, they can then select the
skill set IE Cobol developer or DB2 Developer. The second combo is dependent
on the first. The problem is, the user may need a mainframe developer who is
versed in both cobol and db2. To handle this I give them a button, they
select from the first combo, then the second. Then they click the button and
the skill is added to a list box containing all the skills they need this
resource to have. Once they are finished they submit the request. I add all
the information about the request to a table (tblRequests) I am taking the
rowsource for the final list box and dumping it into a single text field in
tblRequest. Later on the person who is processing the request needs to see
these skills displayed in a list box on a different form. Unfortuneatly the
data is returned as Cobol Programmer;Db2 Programmer instead of "Cobol
Programmer";DB2 Programmer" which is the expected format for a value list
rowsource.

Do I need to write these skills out to their own table?

 

[Guest]

writing them to a separate table would be the better approach; however, you
can do what you want.
Using your example of "Cobol Programmer;Db2 Programmer", we can transform it
so the row source can understand it. Lets say that string is in a field
called [SKILLS]:
Me.MyListBox.RowSource = chr(34) & replace(rst![SKILLS],";",chr(34) & ";") &
chr(34)

Warning, untested air code.

 

[Guest]

I'll try your "Air Code" and see what I get otherwise I'll write them to
their own table.

Thanks again!
--
Michal Joyce
Project Management IS Analyst
Aflac - Project Management Office

writing them to a separate table would be the better approach; however, you
can do what you want.
Using your example of "Cobol Programmer;Db2 Programmer", we can transform it
so the row source can understand it. Lets say that string is in a field
called [SKILLS]:
Me.MyListBox.RowSource = chr(34) & replace(rst![SKILLS],";",chr(34) & ";") &
chr(34)

Warning, untested air code.

Yes, I'll try to clarify...

I have a combo that holds resource types like Mainframe Developer or Web
Developer. Once the user selects the resource type, they can then select the
skill set IE Cobol developer or DB2 Developer. The second combo is dependent
on the first. The problem is, the user may need a mainframe developer who is
versed in both cobol and db2. To handle this I give them a button, they
select from the first combo, then the second. Then they click the button and
the skill is added to a list box containing all the skills they need this
resource to have. Once they are finished they submit the request. I add all
the information about the request to a table (tblRequests) I am taking the
rowsource for the final list box and dumping it into a single text field in
tblRequest. Later on the person who is processing the request needs to see
these skills displayed in a list box on a different form. Unfortuneatly the
data is returned as Cobol Programmer;Db2 Programmer instead of "Cobol
Programmer";DB2 Programmer" which is the expected format for a value list
rowsource.

Do I need to write these skills out to their own table?