Use listboxs to select multiple answers for table

K

KMc

Morning All
I'm currently using MSAccess 2000, and need to use a list box so users can
choose/ click on multiple answers (up to 5) that are then saved to the
underlying records in the table when the user clicks on the save button. I
have tried various ways to do this but all to no avail. Would really
appreciate some help/ guidance with this issue.
My form's name is frmInquiry, the underlying table that needs saving into is
named tblInquiryCalls and the individual records names within this table are
called Issue1 through to Issue5. The unbound list box on the form is called
lstAvailableIssue.
Many thanks for your help
 
K

KMc

Hi Larry
Am uncertain what you mean by this, have looked in 'Help' in both MSAcess
2000 & Visual Basic but am none the wiser.
 
L

Larry Daugherty

Open any module, standard or form module. That will get you into the
VBA Editor. In Help, look for the Selected Property. The example
they used to use is exactly the solution you seek.

HTH
 
Top