auto select first record

[raffi]

hello friends, i have a data entry form,a location combo-box and an item number combo-box



the combo-box i would like to auto select first record is the location combo-box, the location combo-box is requeried and updated based on what item i insert in the item combo-box

[NTC]

you need to determine the 'first' record of the combo box and then write that value into the combobox..... let's say the combobox shows
1 France
2 England
3 Germany
and it is bound to the key field (integer)

then you must determine which is the 'first' record - not sure how that is done in your case - and then put Me.ComboBox = 1 after the requery

[pbaldy]

Or try

Me.ComboName = Me.ComboName.ItemData(0)

[NTC]

= Me.ComboName.ItemData(0)

that's a new one for me - will have to give it a try sometime......though not sure I've ever needed to auto fill the combobox beyond just a default value......

[raffi]

oh i need to auto select the first record cuz every item has a different location, the location combo-box always changes based on what item i have in the item combo-box. and thx guys when i go home ill give it a go

[raffi]

Or try

Me.ComboName = Me.ComboName.ItemData(0)

i include this in afterupdate event of the item combo-box ? because in the item combo-box i already have a (not code) but macro requery serialNumber Combo-box

[raffi]

it worked i set the code in the item on click event and now i dont have to choose the location it will auto select the first record many thanks for the information which u have provided me with

[pbaldy]

Happy to help!