Combobox dropdown last record in form

[phpatrick]

    Me!refSHIFT1.SetFocus
    Me!refSHIFT1.Dropdown

This code dropdown a combobox. However, I use a continious form, where the combobox is multiplied for more records. He always dropdown the combobox on top en not the last added record. How can I say that he need to select the last one ?

regards

 

[TheAceMan1]

How are ya phpatrick . . .

The combobox for the [blue]currently selected record[/blue] should be the one to dropdown. Try:

[blue][purple][b]Me.Recordset.MoveLast[/b][/purple]
Me!refSHIFT1.SetFocus
Me!refSHIFT1.Dropdown[/blue]

BTW: is the combobox [blue]bound or unbound?[/blue]

See Ya! . . . . . .

 

[phpatrick]

I give it a try, I test it.
the combobox is bound (with a reference key)

bye, see you

 

[phpatrick]

yep, with a little help from my friends, ITS WORKS !

 

[phpatrick]

I think a little bit further.
It can be the last one, but not necessary.
The user clicks his record in an ad random order.
In other words it should be the currently selected record.
.MOVELAST is not the best option in this case. I should use code to mention the selected record.
I do some trial and errors, but if you know let me know...

 

[TheAceMan1]

phpatrick . . .

I believe your fighting an [blue]operational problem[/blue] here. Your origional code will do what you want,

[blue]the user has to select the record of interest first![/blue]

The question is . . . [blue]how are you triggering the code?[/blue]

In any case try this in the [blue]Got Focus[/blue] event of the combobox:

[blue]   Me![purple][b]ComboboxName[/b][/purple].Dropdown[/blue]

See Ya! . . . . . .