Updatable Table filtered by Query

R

Ripper

I have a form bound to a table of available tests for a summer Credit By Exam
Session. I created a query that finds only the tests that were signed up for
by students.

I need to update information on each test for the day the test is given and
what session the test is in. I tried just linking the TestID from the Table
and the TestNum (they are the same) from the query to limit the records
available on the form. However, the form is no longer updateable.

How can I use the query to limit the table information on the form so that
only the tests that are signed up for appear? There are 157 available tests,
but only about 25-30 tests are signed up for. I don't want to update all 157
if I don't have to.
 
G

Golfinray

You said one key phrase, "the form is no longer updateable." Why is the form
no longer updateable? If your table or query is not updateable (has the arrow
and asterisk at the bottom) then your form won't be either. Second, is there
a field in your query for date of taken tests or some filed that indicates
the test has been taken? If not, you will have a hard time querying on it. If
a date the test was taken is there, you can add in the criteria of the query
Is Not Null and it will spit out only those hat have taken dates.
 
R

Ripper

I guess I didn't explain.
You said one key phrase, "the form is no longer updateable." Why is the form
no longer updateable? If your table or query is not updateable (has the arrow
and asterisk at the bottom) then your form won't be either.

I am attempting to filter a table using a query AND make the current query
updateable. Unfortunately I am unsuccessful in that attempt.

The table (tblTests) is a list of all possible tests and not results of a
test. They are listed for the students to select courses to take. After
student selection, I created a query that lists all the tests selected by the
students (31 different tests in varied quatitiy).

I linked that query (qryTestCounter) using tblTests in a new query by TestID
and TestNum (Listed in my origional question). I am only using the query to
limit the tests that display. All the information from the table is
available on the query for update, but by linking the test counter query, the
current query is not updateable. What I am asking is how can I limit the
records shown from the test table to only those tests selected by the
students? There are 130+ tests available and only 31 tests selected.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top