Access 2003 List Box Question

S

Samantha

I've created a form in Access 2003, and have a list box set up to allow
multiple answers. However, the selections carry over from one record to the
next. How can I set it up to allow different selections for each record?

TIA...

--Sam
 
O

Ofer

You cant anter multiple answers in a list box when it bound to one field in
the table, Form multiple answers you need another table, with a one to many
relation ship.

I would use a subform linked to the new table, with a combo where I can
enter multiple answers.
If you still want to use list box, there is VBA involved to enter the
records into the new table, which mean more work to develope and maintain .
 
Top