ComboBox VBA (1 Viewer)

[coleman01]

Hi, I have a combobox with two columns - e.g.

1001 "Roger Spencer"

When i use:

userNom = comboNom.column(2),

The debugger returns "null"

I thought that the index may have started at 0, so i tried combonom.column(1) and that still returned null.

Any ideas on how to return the second column value of a combobox?

 

[KenHigg]

I didn't even know you could get what was in the second (or unbound), col, but even so, wouldn't you need something like:

userNom = myfrmName!comboNom.column(2)

???
Ken

 

[WayneRyan]

Coleman,

The index does start at 0, and your syntax looks OK.

SomeThing = Me.YourCombo.Column(1)

Wayne

 

[coleman01]

Still get error

all i get is

Run Time error 94 --> invalid use of null

 

[GRM-kenyette]

I Had That Problem , You have To Go To The Properties Of The Combobox And Set The Col Count To 2, Don't Mess With The Code

 

[coleman01]

Still got the error

It's set to 2 but I still get the error?

Any ideas anyone?

 

[RoyVidar]

Is there a selection in the combo when the error occurs?

The problem probably occurs because of that, and you get an error because you're trying to assign a Null to a string variable, which isn't allowed.

You might for instance test whether there is a selection made prior to this, perhaps:

if me!cboMyCombo.listindex<>-1 then
strSomeString=me!cboMyCombo.column(1)
end if

 

[coleman01]

Cheers

How odd.

I put the if statement in and it still didn't work. After I made the combobox have the focus it worked.

Strange. Thank you very much for that. I really appreciate it.