Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unhappy Unanswered: Auto Number Problem

    I have a problem with my auto number. I have a table called Pass with a field called Pass Number, that is an auto number and a primary key of my table. I have a form to data entry the information to a table Pass, but when I open this form automatically appear a Pass Number in the txtNumber, but if I not fill the form and close the form, the record is add in the table, because have a pass number created. How I resolve these situatuion?

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Well, you could create unbound controls and insert the data with an onclick event from a command button??

    Otherwise I think setting a form to data entry is automatically going to create a new blank record when the form opens.

    Alternately, you could evaluate the current record for null values and delete the record in the onclose event of the form I think.. Don't quote me on that though, I don't know how well forms like to delete the current record.

Posting Permissions

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