field yes/no database

[checoturco]

hi all,

i have a query that select a field(yes/no field) from one table but this query includes some where fields that join two tables. if i run the query i get the field(yes/no) but i can´t check or uncheck this field.

if a made a query that extract this field only based in one table, i can check or uncheck the field

anyone have some advices to get query working with the first query?

thanks all for helping

 

[RuralGuy]

Look in Access help under Troubleshoot Queries and then Select queries. It sounds like you have a non-updateable query for which there could be many causes.

 

[KeithIT]

depending on how your relationship is set and what fields you are pulling, multi-table queries can be non-updateable. If you don't find anything under access help check here for "non-updateable query" to see what people in the past have done to solve this problem.

 

[checoturco]

field yes/no database solved

hi all,

when i put my post i had a sub form with the field that i wanna update, but i still can´t update the field.
with your advices, i made some investigations and i alter my form.
now, i don´t have a sub form but a form with the default view like continuous forms and i change the recordet type of the form to dynaset( inconsistent updates) instead of dynaset only and, voilá, the field was update in the table.

thks you all for helping

 

[RuralGuy]

Outstanding! Thanks for posting back with your success.