Selecting From a Drop Down List 1

[david6633]

I am sure I have seen the answer to this somewhere in this forum but I cannot seem to find it when I need it!

I have a form which is picking up the data from a table and I want to be able to go to a record by selecting a name from a dropdown list which has all the names (in alphbetical order) from the table.

Can anyone help please?

David
Remember: You only know what you know
and - you don't know what you don't know!

 

[PHV]

Take a look at the Bookmark property

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[RoyVidar]

Or try the combobox wizard, third option "find a record on my form...", which will generate the code PHV mentiones.

Roy-Vidar

 

[david6633]

The only problem with that method Roy is that the names are not in alphabetical order - they are in table order!

David
Remember: You only know what you know
and - you don't know what you don't know!

 

[RoyVidar]

There is no problem with that.

Take a look at the combos row source. It's an ordinary sql select statement, where you can use an ordinary sql order by clause (or if you prefer, use a stored query and use the grid to select asc/desc), which will make it appear just as you like.

Roy-Vidar

 

[david6633]

That's great Roy thanks - works a treat

David
Remember: You only know what you know
and - you don't know what you don't know!