ListBox Issues... (1 Viewer)

[kostaskir]

Hello Boys,

I was wondering if you have any useful articles or samples to propose according List Boxes.

I want to add values to a listbox from an edit box through a button ADD.
(Actually this is a List of CD Tracks. I want to save this list in a database field. Is this possible ?)

But I don't know much about listboxes.

Thank you !

 

[John Big Booty]

It should be quite straight forward. Your Add button should open a form through which your user can add new data to the DB. It will just be a matter of re-querying the ListBox when that form is closed. The code in the On Close event of your form would look something like;

Forms!FRM_FormwithListBoxOnIt!ListBoxName.Requery

 

[kostaskir]

Ok. It is clear.

But what If I want to add values direclty from another Edit Box ?
Without Opening another form.

What Row Source Type I have to declare? Table / Query or Value List ?

Thank you.