current record

[phpatrick]

I have a continious form.
When I am on a certain record and I use the event onclick on a textbox he should dropdown the listbox beside the textbox (in the current record).

How to select the list-box of the current record.

Me.Requery
    Me.Recordset
    Me!refDropDown.SetFocus
    Me!refDropDown.Dropdown

 

[ZmrAbdulla]

Why not using a combobox?

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[phpatrick]

It is a combobox, not a listbox, name confusion.

 

[Remou]

Have you tried setting the focus to some other control and then back to refDropDown before the dropdown action?

 

[phpatrick]

No, I did not.

 

[Remou]

Does changing the focus solve the problem?

 

[phpatrick]

no, he always jump to the first record of my continious form

 

[ZmrAbdulla]

Because it does the form Requery. Remove that part of code.
then if you want refresh the combo
use any of the following and try.

Me.Combobox1.Refresh
Me.Combobox1.Requery
Me.Combobox1.Recalc

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[Remou]

The jump to first record is caused by Me.Requery. Do you need to requery? If so, you will need to save the ID of the current record and go back to it after the requery.

 

[phpatrick]

yep, great, it works, life can be easy with a little help.
I need to requery but I do this now after the combobox.dropdown

txs