Getting a blank row after a set of data is entered

[snipe]

Hey guys,



My office staff uses my Access program for data entry of customers names and info. When they key the last name on their list, they usually hit "New Record." They are under the mentality that it is more of a "Save last record" button. This leaves me with a bunch of blank rows in my database.

This isn't a big deal as of yet, but as the database grows, so will the blanks. I was just curious if there is a way of not creating a record unless certain conditions are met. All of the fields have a validation rule of "is not null" but it never gets to that point when they just hit "new record" and then close out of the form.

[June7]

Why does moving to new record row commit a blank record in table? Is New Record a custom button? What is the code?

[snipe]

It's a single form. New record button is custom, it copies some of the data that we want to stay the same until changed by the user.

Dim subdate As String
Dim galleytype As String
Dim custtype As String
Dim storenum As String
Dim Salesperson As String
Dim addate As String




    subdate = Me.Entry_Date
    galleytype = Me.Galley
    custtype = Me.Type
    storenum = Me.Store
    Salesperson = Me.Salesperson
    addate = Me.Sale_Date
        
    DoCmd.GoToRecord , , acNewRec
    
    Me.Entry_Date = subdate
    Me.Galley = galleytype
    Me.Type = custtype
    Me.Store = storenum
    Me.Salesperson = Salesperson
    Me.Sale_Date = addate
    
    Me.Title.SetFocus

Now it's obvious as to why that record gets created...

[snipe]

Here's a snip of the form:



The controls on the bottom right are hidden. The data from the controls on the top in the header are duplicated to those hidden controls After Update, as well as when a new record is added via the custom button.

What I would love, if it is possible, is:
-User enters data in the controls in the header
-User proceeds to fill in the detail section and adding new records (while the header data stays the same and is part of each record in the table)
-Once a user needs to change which salesperson the data is for, they change that from the combo box in the header, and proceed to the detail section
-Continue until all sales people's data have been entered

[June7]

Instead of code to populate fields because this initiates a record, maybe set the DefaultValue of the controls. The DefaultValue will not trigger until user makes an entry into any field of the new record.

[Missinglinq]

As June7 suggested, to avoid creating a 'blank' Record you can use the AfterUpdate event of the Control holding your data to set the DefaultValue for the Field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each New Record, but if no additional data is entered no new Record will be created. The code would be like this:

Private Sub YourControlName_AfterUpdate()
   Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """"
End Sub

This syntax is valid for Text, Number, DateTime and Boolean Datatypes.

You’ll need to do this for each Control that you want to ‘carry forward.’

Linq ;0)>