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?
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.