Current Date button on Report

[Steven.Allman]

I have a report in my database that shows past due information. Each record has an Email and Update button.
The email button works great, but I cannot get the Update button to work. I only want it to add a date to a field.
I know that SPACES in my table names are an issue, but I have been able to code around that all this time. I cant get past it here though.. Anyone got ideas? Here is what I have tried


Private Sub Command10_Click()
Positive_Packets.RX_2nd_Request_Date = Date
End Sub

Variations include
! vs .
[Square brackets] rather_than_underscore
and millions of combinations
If I [Square Bracket] it tells me it "cant find the field "|" refered too"... That is the most annoying part of it all

[Access_Blaster]

Do you want the current date? or the date from your table?

I only want it to add a date to a field.

Private Sub Command10_Click()
Positive_Packets.RX_2nd_Request_Date = Date()
End Sub

[Steven.Allman]

Current Date
I use the email button for notification and then hit the update button so that it inputs a date (NOW) into the "2nd request" field

[Steven.Allman]

FYI, access 2007 will drop the () automatically. It is no longer needed

[Steven.Allman]

You know what, I dont have any reference to the current record. I am mildly retarded.. This has stumped me for a few hours.

[Steven.Allman]

Private Sub Command10_Click()

[Positive Packets].[RX 2nd Request Date] = Date
stLinkCriteria = "[Case Number]=" & "'" & Me![Case Number] & "'"
End Sub

Now my question grows... So how do I get that update to look at my particular record.

[Steven.Allman]

Here is my database, so you can see what I am trying to do. The data has all been deleted minus one FAKE record. The report shows the records that meet the query from the table. I want the button on the report to update the field on the table. The email button works great. I want the DATE button to work the same way. When I hit the email, it grabs the email address relevant to the record. When I hit update, I want to change the date only for that record..

[ssanfu]

I have a report in my database that shows past due information. Each record has an Email and Update button.

Do you mean you have a FORM with 2 buttons on it??? I don't have A2K7, but AFAIK, a report is view only - buttons don't activate on it (the report).

Any chance you could convert the sample mdb to A2k3 (A2k) format?

[pbaldy]

I don't have A2K7, but AFAIK, a report is view only - buttons don't activate on it (the report).

2007 introduced a new "Report" view that is interactive.

Steven, you want something like this:

Option Compare Database
Option Explicit

Private Sub Command10_Click()
  Dim rstPositive_Packetslst  As DAO.Recordset

  Set rstPositive_Packetslst = CurrentDb().OpenRecordset("SELECT * FROM [positive packets] WHERE [Case Number]='" & Me![Case Number] & "'", dbOpenDynaset)
  rstPositive_Packetslst.Edit
  rstPositive_Packetslst![RX 2nd Request Date] = Date
  rstPositive_Packetslst.Update
  
  Set rstPositive_Packetslst = Nothing
End Sub