Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Thanked 0 Times in 0 Posts

    form:link fields (Access 2000)

    Hi, I have a table with action items and update fields. Each week I record an update against all open actions. I have created a form to create new actions but want to create a form to edit existing actions but save these updates as a new entry in my table.
    I.E. Once I select my action number from a drop down list, I would like to populate the values in my form (Assigned to, description, due date, etc) and fill in new information in a [update comment] field and this new entry would be saved as a new row in my data table?

    Any help would be much appreciated!

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 41 Times in 40 Posts

    Re: form:link fields (Access 2000)

    You wrote:
    >>I would like to populate the values in my form <<

    Do you mean you want to automatically populate these values? You would need code in the afterUpdate event of that combo box, but what you do depends on where you are getting the information from.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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