auto populate date value when editing records on a forum?

[LaserSailor]

I have what seems to be a simple question but no luck finding an answer in the archives.

I have a continuous form (for conducting parts inventory) which a user will use to edit a couple of fields and have set the Tab Order to skip over certain fields to discourage editing

• The user will edit the QtyOnHand
• there is a field called Count_Date which I would like to be automatically fill with the the present time when that control Gets Focus.
  
  • to achieve this goal,
    
    • the On Got Focus property of the Count_Date field/control on the form is = Now()
    • the Format property of the control is Long Date
    
    
  • this works perfectly if I add a New Record at the bottom of the form, in fact the date value is already in place for a new record but nothing happens when the focus moves to the Count_Date control when editing existing records
  • the reason for the Count_Date field is to enable tracking the editing of the records.
  • the datasource for the form is a query: SELECT Inv.LOCATION, Inv.PARTNO, Inv.PARTDESC, Inv.ALTPARTNO, Inv.ON_HAND, Inv.Count_DateFROM Inv
    WHERE (((Inv.LOCATION) Like "a*"))
    ORDER BY Inv.LOCATION, Inv.PARTNO;
  
  
• in attempting an easier solution, I added a YesNo field Counted thinking that the user could simply check the field when it was counted but if one clicks the checkbox, it applies the check box to all records. Clearly I am missing some fundamental issues.
• LATEST UPDATE: I created a copy of the same form with the datasource based on the underlying table instead of the query cited above and at least the check box action applies to the specific record so that is a viable solution.
  
  • the autofill of the Count_Date function does not work when the cursor lands on that control despite the properties assigned.

Suggestions? Thanks in advance

[June7]

I don't understand what you mean about setting the GotFocus property to =Now(). I just tested this and does not populate the field even for new record. Does nothing. This expression should not be in the event property. Need VBA or macro. Select [Event Procedure] then the VBA code would be:

Me!Count_Date = Now()

[LaserSailor]

thank you for the reply.

I clearly don't know enough about what I am doing and don't feel it's responsible or considerate to ask these fundamental questions to the group. I will simply use the form which has the table as its data source and the checkbox field / control

Stay warm and thanks for taking the time to moderate the forum