Multiselect list box to open table

[PeggyBall]

Hello,
I would like to create a form with a multiselect listbox where the user can select one or several names to open either a table or another form showing only certain fields so they can update records.

Main table:
tblStudents
LastName
FirstName
Address
City
State
Zip
HomeRoom
Teacher
Conference

User opens form to select as many student names as necessary, click a button to open the table or another form showing only the select LastName, FirstName, HomeRoom, Teacher, Conference fields (not all fields in the table) and then update the HomeRoom, Teacher and Conference fields.

 

[TheAceMan1]

How are ya PeggyBall . . .

Have you considered that you can only update one record at a time? . . . no matter what! . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[SeeThru]

You could use the multiselect to build an SQL query string, and then open a query in edit mode using the query string.

The problem with trying to do this is a form is that you do not know what fields and labels you may need. It would be possible to either add all fields and then hide the ones not used, or possibly even draw the form, add in the fields on the fly - never tried that one.

SeeThru
<a href="

http://www.synergyconnections.co.uk"

target=_blank>Synergy Connections - Telemarketing Services</a>

 

[PeggyBall]

To edit one record I have a form with a combo box and by selecting one name I can go directly to that form but it becomes cumbersome.

Can I make a multiselect list box to select multiple records, open the same form as above but filtered to show only those selected records to scroll through and update?