Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    2

    Unanswered: Automatically adding a value to a field for a new record

    I have a created a form for users to enter visit dates to various clients. The user selects the client (an ID is attached) and then the visit date form opens. At first the user was required to type in the date of the visit but I have now set up a calendar function that allows the user to just click on the date.

    The problem I am having is when the user enters multiple dates at a time. When the user was typing the date my code used the On Dirty event - once the user started typing, the client ID would be attached. However, if the user uses the calendar function the On Dirty event does not take place and the client ID is not attached. I also created an update button that also assigns the client ID but this only works on the last entered visit date.

    Is there some way to assign the client ID to each record on this form automatically?

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Posts
    214

    not sure if it will work or not

    but have you tried other functions like on_change or on_update?
    You know, I'm sick of following my dreams, man. I'm just going to ask where they're going and hook up with 'em later

  3. #3
    Join Date
    Jun 2009
    Posts
    2
    I have tried all of the On Events.

    But thanks for the suggestion!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •