B
Billy Smith
I have what seems like a fairly simple problem. I need to display
in a form a list of employees and for each employee, his job title
like this:
NAME POSITION
Jane Baker Programmer
Arnold Gluck Manager
Harold Adams Marketer
etc.
It's just two matching columns of data that are created at runtime.
The list could have 50 or more names and so must be scrollable.
From what I can tell, I cannot display multiple columns in a list
box. What would be ideal is to be able to make two list boxes be
scrolled by a separate vertical ScrollBar control but I don't think
that can be done.
The best solutions I've come up with are getting pretty convoluted,
e.g. writing the pairs into a database table at runtime and then
displaying the table in a bound subform.
I'm fairly knowledgeable in VBA. I'm doing this in VBA in Access
2000 and thus I can use the MS Forms 2.0 controls.
Any ideas? Thanks in advance.
in a form a list of employees and for each employee, his job title
like this:
NAME POSITION
Jane Baker Programmer
Arnold Gluck Manager
Harold Adams Marketer
etc.
It's just two matching columns of data that are created at runtime.
The list could have 50 or more names and so must be scrollable.
From what I can tell, I cannot display multiple columns in a list
box. What would be ideal is to be able to make two list boxes be
scrolled by a separate vertical ScrollBar control but I don't think
that can be done.
The best solutions I've come up with are getting pretty convoluted,
e.g. writing the pairs into a database table at runtime and then
displaying the table in a bound subform.
I'm fairly knowledgeable in VBA. I'm doing this in VBA in Access
2000 and thus I can use the MS Forms 2.0 controls.
Any ideas? Thanks in advance.