Infomation from lookup table Into form?

[Stephen Evans]

I have a main table with 3 fields for Name. subjects and Knowledge
levels

There are seperate table containing the individuals names, and
another table of subjects taken, I'm trying to get the names and
subjects to list in a continuous form for data imput.

I've been told that the subjects should be held in a lookup table, but
am unsure of how to get the subjects to list on a continuous form.

The form also needs to display an option group bound to the knowledge
field to 5 option buttons to record one of five different levels of
achievement possible in each subject

The objective is a continuous form that displays each Name, the
Subjects and allows the imput of Knowledge reached on a scale of one
to 5

I have not had cause to use Access for many years. If someone can
provide a clear and simple exaple of how this is done I would be very
grateful.

Having tried to get this to work for hours, I'm now desperate!!!

Many thanks.

Stephen Evans

(e-mail address removed)

 

[Steve Schapel]

Stephen

My earlier suggestion to you was to use a combobox for the names and
subjects. If your form currently has a textbox for the names and
subjects, you can right-click on the textbox in design view of your
form, select Change To from the popup menu, and make it into a combobox.
Then, for example with the Subject combobox thus created, you would
look at its Properties, and enter the name of your Subjects table as its
Row Source property.

If your meaning, which I am unsure of, is that each person is assessed
on each subject, then you can run an Append Query to enter all the
Person/Subject combinations in one hit. If this is the case, you in
fact probably don't need the above combobox idea, as the form will nit
be used for data entry of the names and subjects. If, on the other
hand, as I had assumed, some people are doing some subjects and some
people others, I see no option but to enter the records one by one using
your form.