Updating arecord in access form

If there are several tables with a one-to-many relationship, Access does not create the datasheet.

Tip: A view is a way of looking at an Access object.If for some reason the query you have created in not Updateable (some queries like Aggregate Queries are not), then you may want to see if you can build an Update (or Append) Query to update the records you want. " Definitely, if you can use an Update query that's the way to go.If it is not possible to link this table you want to update to the other table and query, then it might require some VBA code, like using ADO or DAO recordsets. Use the built-in Help that comes with Excel/Access 2. A lot of VBA code can be acquired by using the Macro Recorder. IF yo don't mind doing it manually, try jm14's suggestion about the "large" query.Access saves the form unless you are saving for the first time.If you are saving for the first time, the Save As dialog box appears.

Leave a Reply