Listbox 'selected' property problem

[ormsk]

I am running Access 97.

I have a listbox and I want my app to select the first item in the list, so I issue the command:

Me!lstClubs.Selected(0) = True

Then I run a procedure that uses the a value in one of the columns in the list. However, the first item is selected ok and the procedure runs to competion,but then all the controls appear to be locked in some way.

I have encountered this before and put it down to a quirk in Access, but I could do with knowing if there is a work-around, or whether I have missed something.

Can anyone help?

 

[Beeps]

Hi Ormsk,

You could try:

Me.yourlistbox.SetFocus
Chr (13)

I think that the set focus method is available in Access 97. This will set the cursor to your list box and the carriage return will select the first item.

Try putting this on your formload event.

Hope that it gets you started.

Regards,

Brian