List control Issues

[hudaz]

Hi Guys,

Basically i have a list control box which displays data from a query.

I have a macro which opens up another form when a record is double clicked in the list control box and theoretically it should display that record, however it is currently only displaying the first record in the query.

I have tried to use the formula given with ms help (where condition) but the form just loads up solid white.

does anyone have any suggestions ??

apologies if this is a complete Noob question but i've kinda been thrown into access without a paddle as such

thanks

Andy

 

[llkhoutx]

You're not properly identify the selected row and proper column a(hidden or visible) in the list box.