Recordset Not Updatable

  • Thread starter Thread starter Downie
  • Start date Start date
D

Downie

I have a table called jobs
I have a query(print) that pulls certain fields from that table.
I have a datasheet form that is based on the print qry.
I used to be able to enter data in this form by clicking on a datetime
field with the vb code behind it;

Public Sub print_start_Click()
Me.print_start = Now
End Sub

Now when I click on one of the print_start field i get the following
error message;

Run-time error '-2147352567 (8002000009)':

This Recordset is not updatable.

When Debug the following line is highlighted
Me.print_start = Now

Hovering over it displays Me.print_start = Null

Any idea how I can get back to updating this form by clicking the field
inserting the Now() value?
 
Open the query directly from the Database window.
Can you update the print_start field there?

If not, work on the query.
If so, work on the form.

The query results will be read-only if any of the following apply:
.. It has a GROUP BY clause (totals query).
.. It has a TRANSFORM clause (crosstab query).
.. It contains a DISTINCT predicate.
.. It uses First(), Sum(), Max(), Count(), etc. in the SELECT clause
(performs aggregation).
.. It involves a UNION.
.. It has a subquery in the SELECT clause.
.. It uses JOINs of different directions on multiple tables in the FROM
clause.
.. The query's Recordset Type property is set to Snapshot.
.. The query is based on another query that is read-only (stacked query.)
.. Your permissions are read-only (Access security.)
.. The database is opened read-only, or the file attributes are read-only, or
the database is on read-only media (e.g. CD-ROM, network drive without write
privileges.)
 
Back
Top