Editing Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I run a query using two joined tables, I can't edit the data in the
field or if I make a form using the two tables, I still can't edit the data,
but the query is shows all the data fine.
 
Lots of queries return Recordset that are not updateable and if the Query is
not updateable, you cannot edit the data in the DatasheetView of the Query
or the Form which uses the Query as the RecordSource.

Check Access Help on "Updatable Queries".
 
You must log in or register to reply here.

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

Similar Threads

If possible edit the data from query ? 5
Seriously, I need ideas. Fields not transferring from table to table 3
Editing data in datasheet view from a query joining other tables 2
Split data in field on character return 0
Multitable query problem 7
Possible to Edit Query - Got Two Seperate Tables? 4
cant edit records when 3rd table is added 1
A deletion query 5

Back
Top