Working with Listboxes (1 Viewer)

T

The Archn00b

Registered User.

Local time

Today, 07:51

Joined

Jun 26, 2013

Messages

76

• Apr 16, 2014

• #1

Listboxes.

If I select some values from a list box, I would like to be able to use them in Visual Basic. It seems it is a little more complicated than declaring variables form a textbox.

Does any one know how to work with Listbox values in VB? I would like to get the values and execute an append query with the values.

Thanks!

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 07:51

Joined

Aug 30, 2003

Messages

36,124

• Apr 16, 2014

• #2

Is this what you're trying to do?

http://www.baldyweb.com/MultiselectAppend.htm

 

T

The Archn00b

Registered User.

Local time

Today, 07:51

Joined

Jun 26, 2013

Messages

76

• Apr 16, 2014

• #3

Ah yes. Exactly.

What is ctl? Is it a recordset?

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 07:51

Joined

Aug 30, 2003

Messages

36,124

• Apr 16, 2014

• #4

No, if you look at the full code in the sample, it's declared as a control.

 

D

Dayton

Registered User.

Local time

Today, 07:51

Joined

May 2, 2014

Messages

20

• May 2, 2014

• #5

There a way to use those to filter a Report?

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 07:51

Joined

Aug 30, 2003

Messages

36,124

• May 2, 2014

• #6

Like this?

http://www.baldyweb.com/multiselect.htm