How do I update a DAP based on a query?

[Guest]

Trying to update a DAP based on a query but the navigation bar is not active
to add information and the data fields are not updateable.

 

[Ken Snell [MVP]]

DAPs are less tolerant of queries than forms. Some queries that are
updatable in forms are not updatable in DAPs.

However, two common errors that can cause what you see:
(1) You didn't include the primary key of the record to be updated in
the DAP as an element (even if it's hidden).

(2) You didn't specify which table in the query is the UniqueRecordset.

 

[Guest]

Thanks Ken. I do have the primary key include. Not sure where to specify the
UniqueRecordSet in the query.

 

[Ken Snell [MVP]]

You'll need to look at the Properties (data tab) for the specific group or
page.

 

[Guest]

That combination worked. Had to include both/all primary keys and specify the
unique recordset. Thanks Ken!