2 Bound Objects

[mriggio]

I would like to have two bound objects in a list box... is that possible?

If I have a list box with 4 columns and would like columns "A" and "C" to be bound to a table, how could I do such a thing? I've been messing around with a bunch of ideas and none of them work.

Thanks!!

 

[guybrush]

Have you tried to bind the list box to a query?

Add a listbox to the form, right click and go to
properties.

Row/Source type should be = Table/Query

And for Row source, Hit the "elipses" (...) on the right.

This will allow you to build a query. Select the fields you need.

One cool tip is that you can use values on other controls on
the form as criteria for the query that you build. This will
effectivly "bind" the data from the query to the record
being displayed on the form.

let me know if I need to elaborate.