Recordset is not updateable in a DAP

K

Kay

Hello everyone,

I have been reading through the posts and found questions that address
exactly the problem I am having with my DAP. However the solution does not
appear to work. It might be because my form is so much more complex.

The database stores shipping information on medical products. I did not
design it and it does have some mormalization problems wchich I have had to
work around. I have a query that has a zillion fields coming from a main
table and a million lookup tables. I do have the main tables primary key
field on the form and it's
element property for display is set to none. Page Properties Recordset is
set to
dscUpdatableSnapshot. Allow additions, edits,delete is all True and Data
Entry is false.

The query works great on its own and the regular form works great on its
own, but not the DAP. Any suggestions?

Kay
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top