Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add record (2002)

    I have a form where you select a student and then click on a button to open another form where you can add the new record information. When you start to add the info a new blank record pops up. I do not the second blank record to appear because the blank one then becomes permanent for that student.

    Can I eliminate the second blank record?

    Thanks.

    Paul

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add record (2002)

    What exactly do you mean by "a blank new record pops up"? Could you attach a stripped down and zipped copy of the database?

  3. #3
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add record (2002)

    Attached is basic version of database. Open frmAddNewRecord. Select Abbott; Bryon. New form pops up. When you add info to new record a second new record pops up. Go to tblData. Abbott now has records with data and one with only name. That is the record I want to delete.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add record (2002)

    The problem is that frmAddNewRecord is bound (via a query) to tblData, and you have set the DataEntry property of frmAddNewRecord to Yes. This means that simply selecting a name from the LNFN dropdown creates a blank new record in tblData. The frmAddNewRecord form should be unbound, the control source of the dropdown should be blank, and DataEntry should be set to No (although that doesn't really matter for an unbound form).

  5. #5
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add record (2002)

    Thanks Hans.

    You recommendations fixed the problem.

    Paul

Posting Permissions

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