Update Table from Form that is based on a Query

[netrusher]

I have a Table. I created QueryA to filter certain information on the Table. I then created QueryB
Using the Table and QueryA. I linked the Table and QueryA at the Product Field. I then created a Form
based off of QueryB. One of the Fields is a Yes/No CheckBox. I want to be able to update the table
when I click the Yes/No CheckBox but I cannot. I also cannot click the Yes/No CheckBox in QueryB
and update the table. Any advice on how to make the table update from the Form Yes/No CheckBox?

 

[Remou]

This should help:

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_harness.asp

 

[TheAceMan1]

How are ya netrusher . . .

To tell if the returned recordset of a query or forms RecordSource (Allow Additions = Yes) is [blue]uneditable[/blue] have a look at the [blue]AddNew[/blue] navigation button

, if it has that [blue]disabled look[/blue]

then the recordset is uneditable!

Have a look at the following for reasons and fixes: Why is my query read-only?

See Ya! . . . . . .

Be sure to see thread181-473997