Editing record from a query?

[springa]

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!

 

[Rabbie]

The simple answer is Yes. Just base your form on an updataeable query. See this link for information on when a query is updateable or not.