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?
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?