Yes/No Update through Select qry

[Brizhattrick]

I am thinking I am missing something very elementary, but regardless I'll ask.


I have a form which when a user runs a query specific based upon their user
id via a command button a list of tasks appear where the Completed field is
0 (ie not compelte)

Is there a way that the user can change the value to -1 by simply checking
the button on the same query?

Currently it shows The recordset is not updateable.

Thanks in advance

 

[Jerry Whittle]

This is a very complicated subject. I suggest that you open up Access Help,
go to the Find tab, type in "updatable" (lower case u) or "About updating
data", and then scroll down to "When can I update data from a query?" or "Why
can't I edit data in my form?". There you will find a lot of, possibly too
much, information on the subject. In a nutshell, if the query is based on one
table or tables with a one-to-one relationship, you will be able to edit or
delete records. If it is based on two or more tables with a one-to-many
relationship, you 'should' be able to edit or delete records. If you have
three or more tables based on many-to-one-to-many relationships, you will not
be able to edit or delete records. This is just the highlights. Help has much
more information.

 

[Brizhattrick]

I am releived it wasn't something completely obvious.

I took your advice and am still a little confused (actually very confused) so
I'll have to look down another avenue.

The table is one that is qualified to accept updates, but it looks like I
need to define the Users?????

Thanks again