Combo box list (1 Viewer)

[PicassoB]

I have a combo box with 300 customer names in, on selecting the customer it auto fills fields in with address etc.

Is it possible instead of scrolling down the list to required customer, I can put the first letter in the box to select customers beginning with that letter
Have searched the forum but not found any similar posts

 

[pbaldy]

Make sure the Auto Expand property of the combo is Yes.

 

[PicassoB]

Thanks Paul for the responce - checked this and it is set to yes but on selecting a letter the box just flashes and does not open the list at the first name (using 2007 if this makes a difference

 

[pbaldy]

You want the combo to drop down? Try this in the got focus event:

Me.ComboName.Dropdown

Otherwise, I'm not clear on what's going wrong.

 

[PicassoB]

Hi Paul still no joy - the box still just flashes the name but will not hold it
it just wont let you type a letter in
Thanks for the help anyway

 

[PicassoB]

Hi Paul found the problem - but dont know how to solve it
in the on change, I have it to open a autoaddress form, if I take that out it works but I need this it to enable it to fill in all the address fields, any idears how to solve it?

Private Sub Customer_Change()
DoCmd.OpenForm "autoaddressform", acNormal
End Sub
Private Sub Customer_GotFocus()
Me.Customer.Dropdown
End Sub

 

[pbaldy]

The change event fires with every keystroke, which I doubt is what you want. Try the after update event, as that will only fire after the user completes their selection/typing.

 

[PicassoB]

worked great Paul - thanks very much for the help