Re: Multi List box in form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Single Form View is when the form shows one record at a time,
Continuous Forms View is when it shows multiple records, usually with
each on pone row. A form can only contain a subform if the former is
in single form view, but the latter can be in continuous forms view,
single form view or data*** view. I'd recommend using continuous
forms view rather than data*** view, however. The former gives you
much more scope for formatting and you can include unbound controls
such as buttons or navigational controls in its header or footer,
whereas data*** view, while easy to set up does not present a very
professional image and is much more limiting as regards formatting.

To set a form in single or continuous form view set its DefaultView
property in its properties *** while in design view.

In your case I'm suggesting that the parent form be in single form
view, so it will show one course at a time, and that the subform be
in continuous forms view so it will show all attendees at the
currently selected course in the parent form simultaneously in rows.
You can then add or delete attendees from the course simply by
inserting or deleting a new row in the subform.

For an example take a look at the categories form in the sample
Northwind database. You'll see that it has a subform which shows all
products for the currently selected category in the parent form.

Ken Sheridan
Stafford, England

On Feb 27, 12:03 am, "spcscooter via AccessMonster.com" <u30679@uwe>
wrote:
sorry to sound so ignorant but I am not sure what you are referring to as a
single form view and a continuous form view. I have always relied on wizards
to most of my databases, so you can see what I am limited to. I do know how
to do sub forms however. :) If I am asking too much can you refer to a site
or book where I can have examples of what I need to do. Sorry to be a pain.



k...@xxxxxxxxxxxxxxxxxxxxxxxxxx wrote:
To use a multiselect list box for data entry you'd have to write code
to update the table when inserting or editing data, and to select
items in the list box when viewing existing data. List boxes are not
really intended for this purpose and there is a far simpler way of
doing it:

Create a form in single form view based on your Courses table. Then
create a form in continuous form view based on your Course Enrolment
table, but don't include a control bound to the CourseName field in
it. Then embed the enrolment form in the courses form as a subform
linking it to the parent form on whatever are the primary and foreign
key fields by which the tables are related, presumably CourseName.

Its then simply a matter of inserting a new row in the subform for
each attendee at the parent form's current course.

Ken Sheridan
Stafford, England

On Feb 26, 11:02 pm, "spcscooter via AccessMonster.com" <u30679@uwe>
wrote:
I have created a multi list box where I can select multiple employees to
attend a training class. The only problem is that when I click on an
[quoted text clipped - 37 lines]

Message posted viahttp://www.accessmonster.com

--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/20...

.

Quantcast