How do I make a subform act like a list-box?

[Doug]

I need a list-box with conditional formatting. I've seen many posts saying
the only way to do this is by making a subform act like a list-box. How is
this done? I can't find advice/tips/examples online. What is best practice?
Specific questions:

1) how do you pass the key value when the user clicks a row?
2) how do you get the formatting to work so it acts like a list box?

Any help would be much appreciated! Thanks!

 

[KARL DEWEY]

A couple of questions --
Where is the data from for the subform?
Why not use a listbox?
Do you want the subform data to be bound to field in a new record somewhere
or as criteria?

 

[Mike Painter]

I need a list-box with conditional formatting. I've seen many posts
saying the only way to do this is by making a subform act like a
list-box. How is this done? I can't find advice/tips/examples
online. What is best practice? Specific questions:

1) how do you pass the key value when the user clicks a row?
2) how do you get the formatting to work so it acts like a list box?

Forget #2 formatting has nothing to do with it.
Use the on-click or double click event for the field(s) that they click in
to do what you want.

Set it up for just a single field, then cut and paste into any others if
they all do the same thing.

(They don't have to. A double click on a date fieldcould bring up all the
records related to that row sorted by date and double clicking in the first
name could bring up the same list sorted by first name.)