passing a value from a text box to a list box (1 Viewer)

duke217 · Jan 23, 2018

Hi all,

My issue:

I have a text box, called CID on a form.

With a click of a button I would like to pass the value of that text box to a box where I see a list of values taken from a table (the name of the list box is Customer)

I used this in the code for the onclick event of the button:

Me![Customer].value = Me![CID].value

And when I click, I get error 2113 : the value you entered is not valid for this field

It is gently driving me a little bit crazier than I already am :banghead:

any thought, o ye the wise?

arnelgp · Jan 23, 2018

your code will work, but...

did you include the CID (ID) on
the Listbox, and set the Listbox's
Bound Column Property to CID?

If CID is in column 1 you set
also the Bound Column (Property->Data) to 1,
else to whichever column the CID is.

duke217 · Jan 25, 2018

Thank you so much for your reply, Arnel.

It triggered two more questions:

1. How do I include the CID(ID) in the list box?

2. The Bound Column numbering starts from 0 or 1?

Thank you again

arnelgp · Jan 25, 2018

drag a new listbox to your form.
the wizzard will guide you. make
sure to select CID first.
the wizzard will ask you if you
want to hide this field, choose Yes.
you can delete the old listbox
and name this new listbox as the
previous one.

bound column start with 1.

duke217 · Jan 25, 2018

Aaahhhh. It worked. My brain just stopped itching.

Thanks a lot!

arnelgp · Jan 25, 2018

Now you saved a tablet of pain reliever.

passing a value from a text box to a list box (1 Viewer)

duke217

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

duke217

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

duke217

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Similar threads

Users who are viewing this thread