Populating a feild from other feilds to produce a product code

[Johnrg]

Populating a feild from other feilds to produce an "invoice product code"

I have a manufacturing plant that combines ten individual component groups to make a finished product.

I have a table setup for each "component group" with an index number, a short description and the full description.

There can be up to twenty individual components in each "component group".

Different products have different combinations of components and as you can imagine there are alot of combinations possible!

When a product is ordered by a customer the operator chooses each component by moving through a subform using ten lookup combo boxes related to the ten component group tables.

After this is process is done I want to populate a new feild in my order form/table with each short description to give me the finished product "invoice product code".
I then want access to check it if it has been ordered/sold before by comparing it to a master "invoice product codes" table. If this combination has not been entered before we would need to add it at this stage to the "Invoice product codes" table.

We create finished goods product codes as we go rather than trying to get them into the database at the start because the combinations are just to great to cover everything.

In excel the formula in the destination feild would be something like:

=Cell1&Cell2&Cell3

Not sure how to acheive the same in Access? Any pointers would be great.

Thanks

JohnG

 

[Johnrg]

Anyone want to have a crack at this?

 

[JPearson]

If you create the combined information behind the form you can use something like this.

dim CbProdCode as string
 
 
cbprodcode= Box1.value & box2.value & box3.Value & ect.

I would probably also set all the box values to "" default to avoid a null error.