Updatable Table filtered by Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ripper - 29 May 2008 20:13 GMT

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.

Signature

Thanks As Always
Rip

Reply to this Message

Golfinray - 29 May 2008 20:28 GMT

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.

> 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
[quoted text clipped - 9 lines]
> but only about 25-30 tests are signed up for. I don't want to update all 157
> if I don't have to.

Reply to this Message

Ripper - 29 May 2008 21:00 GMT

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.

Signature

Thanks As Always
Rip

> 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
[quoted text clipped - 17 lines]
> > but only about 25-30 tests are signed up for. I don't want to update all 157
> > if I don't have to.

Reply to this Message