Form Won't Update Table

[JakeMann41]

Hi Guys



I have 2 tables called LocationTable and NewLocationTable

If a location is changed in NewLocationsTable in the field Location, I have a query that updates the same field in the LocationsTable

Can I create a form that looks at NewLocationsTable and allows me to update from there? I've been trying and so far haven't got it to work.

[June7]

Why would you use a second table to input edits that should be in first table? Why do you have two tables?

Should bind a form to LocationTable and do edits there.

Whatever you tried, it was not provided in posted db so no way to analyze why attempt failed.

[June7]

Sorry accidentally duplicated post.

[ano]

UPDATE LocationTable INNER JOIN NewLocationTable ON LocationTable.Item = NewLocationTable.Item
 SET NewLocationTable.Item = [LocationTable].[Item],
 LocationTable.Location = [NewLocationTable].[Location];

dont know what you thinking
why over ride item that already match?
why is there a second table? why not just change the table if the name change?
why is a new location not an extra location that need to be added? (insert not update)

[JakeMann41]

I'm a complete novice on Access.

When I am binding a form I am finding that I am adding to the table every time I make a new entry. I don't want to do that, i want to update an existing field in a table with an update

[ano]

When I am binding a form I am finding that I am adding to the table every time I make a new entry.

a form is for inquiry and for updating and for adding new at the bottum of the form
read about form (create form)

[Welshgasman]

I'm a complete novice on Access.

When I am binding a form I am finding that I am adding to the table every time I make a new entry. I don't want to do that, i want to update an existing field in a table with an update

Make sure DataEntry is set to No.
Failing that, upload the DB or enough of it to see the problem.

[xps35]

It is not clear (to me) what you really want. Two tables with the same data does not seem logical.

Based on your previous question, I assume you want to change the location of an item. In my sample database I have created an item form. You can then choose a different location via the dropdown. You can only choose a location that already exists in the location table. If you want to use a location that is not yet in the location table, click on the button to first add that location to the location table. You can then choose the newly added location via the dropdown.