Inactive Yes No

[Ian]

I have three tables that I've joined (1:many) in a
query. I want the user to be able to turn on /off a yes
no button on the main table (from within the query) but
the yes/no box won't work when viewed in the query.
What's up?

 

[Larry Linson]

I have three tables that I've joined (1:many) in a
query. I want the user to be able to turn on /off a yes
no button on the main table (from within the query) but
the yes/no box won't work when viewed in the query.
What's up?

More than likely, you have created an un-updateable Query. This topic is
covered in Help, but may be a little difficult to follow. Be sure the
primary key of the main table is included in the Query -- that's about the
only easy, quick possibility I can suggest.

Depending on the tables, joins, etc., it may not be possible to make a given
query updateable.

Larry Linson
Microsoft Access MVP

 

[Guest]

That explains it -- I've got one field that prompts for a
parameter. I bet if I take that out it will help.

Thanks