Recordset not updatable in form

[TRob]

Access '97
I have created a table with two keys....Reference number
and line item number. Both together create a unique
record. This has worked fine until now, but the specs of
my project have been changed.

So now I have a table that looks like this:

Reference No. Line No.
12345 1
12345 2
12345 3
45678 1
45678 2

I'm now attempting to create a form for the user to click
off a yes/no box related to the reference no. I don't
want the user to see the entire list of records, but only
a one liner for each reference no. So instead of seeing
all 6 records above, they would only see 2 (12345 and
45678).

I created a query that I based the form on that creates a
summary on the reference number and it shows what I want
to see. However, the resulting recordset is not updatable
so the check boxes can't be clicked off.

any suggestions?

Thanks!

 

[Allen Browne]

If your table has 3 records where Reference No is 12345, and you are
displaying only one of the 3, which one do you expect to be able to update?

Clearly if the recordsource contains DISTINCT or a GROUP BY clause, Access
cannot give you an updatable recordset.