Saving to 2 cells from one form entry

[davegri]

As others suggest, query is simplest. Do the query like this. Nothing at all need be changed in the table. The form need not be involved. Export the query instead of the table, whenever the table data is ready.

[captiangvp]

As others suggest, query is simplest. Do the query like this. Nothing at all need be changed in the table. Export the query instead of the table, whenever the table data is ready.

Thank you! I will try this now!

[captiangvp]

As others suggest, query is simplest. Do the query like this. Nothing at all need be changed in the table. Export the query instead of the table, whenever the table data is ready.

THANKS I believe this has worked AND it solved another issue i was going to ask about but this helped circumvent it! :P

[Welshgasman]

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

Attachment 46090

You do realise the 'website builder' can do exactly the same thing.

[NoellaG]

a very simple example how to build a query:
https://database.guide/how-to-create...the%20criteria

oeps, didn't look beyond page 1, sorry

[captiangvp]

actually no, the website builder can NOT do it, which is why i had to figure it out on access

You do realise the 'website builder' can do exactly the same thing.