Multi Select Field on Form

[MiAs]

From my example,
Can someone help me or demonstrate with the example how to multi-select names from the ListBox field on the form.
As can be seen,the names in the ListBox come from Table1.
Also, the record is showing 1 of 13(because of the number of names in the table) when I wish it to be 1 of 1.
Help is appreciated.
Hope my request is clear.

 

[Oldsoftboss]

This example shows how to loop through the list box. Hope that is what you are trying to achieve.

The reason the record selectors show there are 13 records is because your form is bound to the table. If you only want to show a list in the listbox, the form does not need to be bound.

Dave

 

[MiAs]

Based on the example,
if I want to now go to a new record and save my selection from the list in the field how do I set this up?

 

[Oldsoftboss]

Try this.

Form 1 is now based on table 2 and using table 1 as a look up table. I would not reccommend this as you are storing the data twice in your database. But you asked.

Form2 is based on a query that looks up the data in table1 but only stores the ID No. This is the way to go and is worth the time to learn.

Form3 add the data straight to a table. Good if you do not wish to use the data straight away.

HTH

Dave

 

[MiAs]

Dave,
Thanks for your suggestions.
I have become confused with this lot and need to re-think what I am trying to do.
Basically, it is to simplify the task of multi selecting fore and surnames from a table into a form field,the table is accurate and updated daily, thus avoiding manual typing of names into the field and risking spelling mistakes.
A selection of names,sometimes up to 10, would then create one record before moving to a new record.
Does this explanation help?

 

[Oldsoftboss]

A selection of names,sometimes up to 10, would then create one record before moving to a new record.
Does this explanation help?

Not really, How are you going to store these names? Seems you need to create a record and the a subform of names related to this record. Maybe you could post a sample Db to help explain.

Dave

 

[MiAs]

Dave,
Your suggestion of a subform to the record sounds like what I may need.
How do I set this up?
Could you show me using one of the examples?