Combo Box Show all values before selection

[INvicta]

I am sure the answer is relatively simple but I can't work it out.

I have a Combo Box on a form.
Row Source is set to Wayne;Roger;Lesley;N/A

When the focus is on the box it would be useful for the whole list to be shown (as opposed to selecting the drop down arrow).
Then the value selected to be entered in the field as normal.

Any help would be very much appreciated.
We have a new accounts package due to be implemented soon. The Go Live date has now been put back 3 times. Meanwhile this so called interim option continues to run without problems. Funny old world isn't it

Bernard

 

[Andrew Fergus]

Hi Bernard

How about using a list box instead of a combo box? A list box naturally shows more than one item in the list at a time. The main difference is you can have 'multi-select' with a list box so you may want to set that property to False if you want your users to only select one value at a time.

Andrew
[edited typo]

 

[INvicta]

Andrew,

This gives me the visible list =

I've tried it but it keeps defaulting to the first value in the list (Wayne) even when another is highlighted\selected.
How do I get the name that is selected from the list entered into the Op Id field?

Sorry for being so dense - Double clicking, to select, the appropriate name does the trick.

Many thanks for your help.

Bernard

 

[CT Witter]

You can try this as long as your are only selecting 1 item

Private Sub List2_AfterUpdate()
Me.Text4 = Me.List2
End Sub

Change List2 to your listbox name and Text4 to the OpId field.

HTH,
CT

 

[INvicta]

CT,
Many thanks
Bernard