Results 1 to 2 of 2
  1. #1

    frmFindVisit (2007)

    Please help,
    1. When I add a record to "Patients" table I want SocSecNo, lname, and fname to be added to "Visits" table,
    2. I want to open frmFindVisit" form, load a SocSecNo, make changes and save a record with new changes as well as keeping the existing record as is.
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Mt Macedon, Victoria, Australia
    Thanked 45 Times in 44 Posts

    Re: frmFindVisit (2007)

    Add a Visits subform to the patients Form, linked by p_socsecno. When you add the Date of the visit to the subform, the Visit record will be created, and the SocSecNo added automatically. The Visits table should not contain fields for lname and fname as they come from the Patients table.

    When you use the form to find a patient it shows you the last visit for that patient. If you change the record then record is changed. If you want to add a new record then don't edit the existing one.

    If you have a Visits subform as a continuous form on a patients form, then it would show all existing visits. You could add a visit to the subform without changing any existing records.

Posting Permissions

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