Saving to 2 cells from one form entry

[captiangvp]

I have a project I'm working on and I need to be able to hit save and, for example let's use field 3.


I need to be able to fill out field 3, then when I hit save it'll save to the table into 2 cells instead of just one.
Example:
On the form
Field 1 - John
Field 2 - Smith
Field 3 - city

On the table
Location - city
First name - John
Last name - Smith
Location(2) - city

So is there anyway to hit save on the form and have it save city to both Location and location 2 without having to fill it in twice on a form?

[Welshgasman]

Why do you need to save it twice? Goes against everything a db is?

[captiangvp]

So the table is exported as a CVS file that's uploaded to a website builder and it has 2 fields on the website that is exactly the same. Ik I can just add the field to a form and manually input it but was wondering if there's a vba or code that will auto populate it when hitting save

[June7]

Yes.

Me!Location2 = Me!Location

Might want to use AfterUpdate event of Location.

Or export a query that calculates Location2: =Location1

[captiangvp]

Yes.

Me!Location2 = Me!Location

Might want to use AfterUpdate event of Location.

Or export a query that calculates Location2: =Location1

Omg thank you! Will try this first thing tomorrow!

[June7]

Correction, calculation in SQL would look something like:

SELECT tablename.*, Location AS Location2 FROM tablename;

[Welshgasman]

I would be going with the query method?

[NoellaG]

I would definitely go for the query method. I think a query is the best method to calculate new values out of the existing database fields. However, for export purposes I would not use select * . If a new field is added to the table, it's added to the queryresult and the csv output is altered. For export purposes I would always use a syntax like for example:

select field1, field2, field2 as field3, ect. ... from MyTable where [criteria] order by field1, field2, ...

[captiangvp]

Well.. maybe i'm too stupid, i can't seem to get it to work

[June7]

What do you mean by "can't seem to get it to work"? What doesn't work - query, VBA, export? Error message, wrong result, nothing happens?

If you want to provide sample db, follow instructions at bottom of my post.

[captiangvp]

What do you mean by "can't seem to get it to work"? What doesn't work - query, VBA, export? Error message, wrong result, nothing happens?

If you want to provide sample db, follow instructions at bottom of my post.

No matter what I do the text box on the form returns #error

Wish it were like excel and as simple as vlookup 😅

[captiangvp]

I will provide one when home

[captiangvp]

What do you mean by "can't seem to get it to work"? What doesn't work - query, VBA, export? Error message, wrong result, nothing happens?

If you want to provide sample db, follow instructions at bottom of my post.

I think i did it right.
SO my main goal, is that the "distributor" field on the table "products" needs to reflect exactly what manufacturer is. which i know is redundant but is required for the setup that the website builder has. I know that i can just create a field on the "Products_form" and manually input it or do another drop down. BUT just for automated purposes i'm trying to just get it to either auto copy there, or for a field in the form to auto populate what the manufacturer is and save it to distributor field IF POSSIBLE. If its not possible/easy enough to figure out, no big deal. Thanks for everyone who attempts to help! Its greatly appreciated

Sample DB.zip

[Welshgasman]

I thought we had established that you just need to repeat on the query for the csv

[captiangvp]

I thought we had established that you just need to repeat on the query for the csv

yeah forgot to add i have no idea what this part meant. I'm not an access pro as i'm used to doing tons of work in excel, but for this particular project its required for us to use access and i keep getting stomped on it i've messed around with query wizard but i'm not connecting dots here