Yes, Another Cant Go To Specified Record Err

[Surdeymon]

ok - I have searched multiple forums and I found many posts but none that rectify my issue.

I have a form (frmAllowReview) that is based off of a query of 2 tables with a basic one to one link. That form has a subform (frmAllowList) that is based off of a table. They are linked by an ID called contracthistory#. Ther data looks good but I cannot add a new record to teh subform. The subform is set to Allow Additions, Allow filters is set to N. The recordset Type is set to Dynaset

Whenever I try to add a new record - It states that it cannot go to the specified record...I cannot figure this out. Any other settings I am missing? The table is an ODBC link to a SQL table that has full perms on it.

Thx for any help in advance - Rob.

 

[RuralGuy]

It sounds like you have a NonUpdateable query. You can verify that by trying to change something in the query directly. Look in Access help Answer Wizard for troubleshoot query then Select query.