Hi Gurus!

I have a list box bound to a table. The list displays two columns. One column for a descriptive field and one for a boolean value. e.g.

S04 No
W04 Yes
S05 Yes
W05 No

On the forms load event I would like to auto select the items in the list box that have a Yes value. any Ideas???

You need to set a button on the first form to open the second form, and then link the second form's record source to this list box. The wizard should do this for you automatically if you select open the form and display related data.

If not, you need to capture the bound values of the list box in variables, and then create a link criteria to your second form. I can do this with single values in combo boxes, but have not done this for n values from list boxes. I know I have seen a post on this recently.

HTH

mmcdonal

I think it would be possible to do this in two other ways.

1. Focus on the list box, and see if there is a Select Method on the list box to select the ones you want. I think this should be possible. The Focus on the list box may not be necessary.

2. Focus on the list box, and use the SendKeys command.
Here's a bit of the manual in Access 2002.
Sends one or more keystrokes to the active window as if typed at the keyboard.

Syntax

SendKeys string[, wait]

----
SC