Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unhappy Unanswered: I want my subform to allow adding only one record at the time

    Hi everyone,

    I have the following problem:

    I have a form with subform. The relationship between them is one-to-many but when user fills them (in one instance of the form) the subform should allow only one record to be added. How can I do that?

    (The way it is now - when the user hits ENTER after the last field of the subform it opens a new record and that way the user can add many records in the subform)

  2. #2
    Join Date
    Aug 2003
    Use the event AfterUpdate of the subform to send the focus to form.
    Then when the users add a record the focus return to the form.

Posting Permissions

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