Multiselections

T

Tony

Does anyone knwo how to keep a selection box to hold the data that it has in
it when you switch between records on a form? Example, is when I choose
multiple selection in the selection box and then go to the next record and
back to the record I wasjust on it show s that no selection have been made in
the box. Does anyone know the cause of this and the fix? Thanks in advance.
 
A

Albert D.Kallal

The problem is that you don't state where you want the multi-selections to
go?

You can't really stuff "many" values into one field.

(well, I suppose you could forget about data design, and put everyone's
address into "one" record, but then you can't use any kind of reports etc on
this "one" huge record.

So, the problem is not the cause, the problem is that you don't mention
where these selections are to be save. You can't put 5 companies address
into "one" address field. So, those multiple selections have to go
somewhere.

A listbox is a better control when you want to "prompt" a user to select a
few things, and do something. However, to "save" this data, then a listbox
don't work well.

You can write a whole bunch of code to take each selection, and write it out
to a table, but the problem comes when you got back to the record, you will
have to read that data from the table, and then load up the listbox. Even
more difficult here is that when you de-select a selected value in the
listbox, you now go to go back to the table, and remove the selection.

If you don't want to write all of the above code, then the "no code"solution
is to use a sub-form.....
 
Top