Hi all,

I am running a database which records pricing errors for items. I have run a query on the main table to show all pending price corrections and have also built a form to allow the user to scroll through these pending price issues. However, I am unable to change/update any fields in the form and am guessing this is because the records are linked to the query and not the table. Is there a way that I can limit the records that show up in the form and still be able to change them?

Please help!

The simple answer is Yes. Just base your form on an updataeable query. See this link (http://allenbrowne.com/ser-61.html)for information on when a query is updateable or not.