Adding New Records Issues

[Lin13]

Im new to access and this is my first database.
I have created a navigation pane with each tab linked to a query to show records selected from a list box. Also on each tab is a button for Add New and a button for Edits.
Both the Add New and Edits are linked to forms for the original table being edited/added to. There are also Save and Close or Save and New buttons on each Edit/Add Page.

The problem I am having is that when I try to add a new record ( havent tried edits yet) the following issues occur:
1. the new first name being entered takes over a record that already exists.
For example, I am entering data on Carrie Smith (phone, email, etc.) When I look for the new entry in the Employee table, it shows up as FirstName - Samuel LastName- Fry FullName - Ben Franklin and the detail information is about Carrie Smith.

** FullName is the main connection, but EmployeeID is the look up for FullName in all other tables except Employees. (inner joins were used in the forms based on queries (the view only forms), i know this is a no-no but it had been working until the edits)**

2. Another name shift also occurs. Using the above example, if I then remove the error record and recheck my table I now have two records for a completely different person.


Example, Mary Jones - details
Mary Jones - details from above example
Then, in the employee list box, only one mary jones is displayed.
This may occur in table that is not the one being edited (not Employee table)

Im at a total loss other than Ive set up the forms incorrectly.

Thank you in advance!

[June7]

Sounds like not creating new record but editing existing. Need to move to a new record row and enter data. If you are using a combobox to enter search criteria then it must be UNBOUND, otherwise will just change value in record.

[Lin13]

The "edit" form is using a combobox that is unbound. The add new form is using text boxes linked to the original table and is set to data entry.

[June7]

Then I am also at a loss. If you want to provide db for analysis, follow instructions at bottom of my post.

[Lin13]

So after playing around more we've come to this summary:

The forms I am using are automatically updating when I dont want them to.
If I add Joe Dirt, into the employees form he will be added just fine. As soon as I click over to the next navigation tab is where things get bad.
As soon as I click on the 2nd tab, the information for the last person viewed is given to the new employee.
Then, there will be 2 records. One will be the original viewed person, and the second will be the viewed persons info but in the 1st records spot and the first and last name of the 1st persons records.

For example if I am viewing Lori Smith and Add Pope Romeo, I will get 2 records for Lori. One will be her own original data, and the other will be bumped into the first records spot. The new person will take his own record. When I click on the next form, with the new person Pope selected, Pope will take Loris info and will update all the other forms in the same way.

I will update a database on Wed.

Thanks for your help

[Lin13]

uploading database later today