Help - Records not always saving to table

[Lejano08]

Hello.
I created a simple database at work that some employees use to enter transportation requests.
Lately I have been hearing that when requests are submitting, they do not save to the tables. (There is a report screen in the database that shows you the records that already exist, and the new requests do not appear on the list, so sometimes users have to re-submit). Only 3 people have reported this, and it seems to only happen when they are submitting more than one. For example, if they are entering two, the first one will not save, but the second one will.
They submit the second one using the 'Add New' button, after submitting the first request. This clears the text boxes so they can enter new info.

Has anyone ever heard of the Add new Record button possibly overriding the record that was saved prior to clicking Add New? I cannot pinpoint why some save, and some do not.
When I test it out myself, it works like it should.

Please help.

 

[jdraw]

Please tell us more about your database. Is it split into Frontend/Backend? Does each user have a copy of the Frontend on their PC?

 

[Lejano08]

Yes it is split. Everyone has the front end and only me and another person have access to the backend.
The submit button has VB code that saves the record to the table and sends a "Thank you, your request has been submitted." message. As far as I've always tested, if you see this message, it goes into the table, and you can see this in the report view.
The 'Add New' function is the regular embedded code from Access. As far as I know, it just clears out the fields so you can enter a new record.

 

[jdraw]

Can you show us some code?
Does each user have their own copy of the FE on their PC?

After posting:

I saw the other thread. You have responded to a discussion from last summer.
Let's work with the current situation and your thread from today.

If you think you have corruption, then give readers the details. Let's not spread this across multiple posts.

 

[Lejano08]

If IsNull(Me.Request_Date) = True Then
MsgBox "You must enter the request date."
Me.txtRequestDate.SetFocus

ElseIf IsNull(Me.Patient_First) = True Then
MsgBox "You must enter the patient's first name."
Me.txtPFirst.SetFocus

ElseIf IsNull(Me.Patient_Last) = True Then
MsgBox "You must enter the patient's last name."
Me.txtPLast.SetFocus

ElseIf IsNull(Me.Street_Address) = True Then
MsgBox "You must enter the patient's street address."
Me.txtStreetAddress.SetFocus

ElseIf IsNull(Me.City) = True Then
MsgBox "You must enter the patient's city."
Me.txtCity.SetFocus

ElseIf IsNull(Me.State) = True Then
MsgBox "You must enter the patient's state."
Me.txtState.SetFocus

ElseIf IsNull(Me.Zip) = True Then
MsgBox "You must enter the patient's zip code."
Me.txtZip.SetFocus

ElseIf IsNull(Me.Patient_Phone) = True Then
MsgBox "You must enter the patient's phone number."
Me.txtPPhone.SetFocus

ElseIf IsNull(Me.Appt_Date) = True Then
MsgBox "You must enter the patient's appointment date."
Me.txtApptDate.SetFocus

ElseIf IsNull(Me.Appt_Time) = True Then
MsgBox "You must enter the patient's appointment time."
Me.txtApptTime.SetFocus

ElseIf IsNull(Me.Destination_Address) = True Then
MsgBox "You must choose the patient's appointment site. If it is not listed, choose OTHER."
Me.cmbDestinationAddress.SetFocus

ElseIf IsNull(Me.Requesting_Staff) = True Then
MsgBox "Enter the name of the staff member who submitted the request."
Me.txtRequestingStaff.SetFocus

Else
DoCmd.RunCommand acCmdSaveRecord
Me.txtOtherDestination.Visible = False
MsgBox "Thank you! Your request has been submitted."
End If

 

[jdraw]

Where exactly is this code? Which event?
I think you should also be checking for zero length string (ZLS).

If (len(MyField & "") = 0 Then field is empty "" represents a zero length string

 

[Lejano08]

It is in the "submit" button. It saves the record when they click it, but reminds them if they leave something blank so that they can't submit anything with black fields.