Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    11

    Unanswered: end of record question

    how can we do this in ms access?..what we want is that when the form loads
    all the fields are set to blank and not the fields with the previous records.
    We want the form to be ready to be filled for a new record.

    On what we are currently doing when the form loads it shows the previous
    records so we need to click the add button just to add new records and thats
    what we dont want to do.

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Use:

    DoCmd.OpenForm "yourFormName",acNormal,,,acFormAdd


    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


Posting Permissions

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