automatically store as a record the value of a textbox of another form

[Gilberto]

Hello, this is my situation:

On the first form (PROJECTS) i have a textbox (PROJECTNAME) which the user enters when opening the database.

On a second form (ENGINEERING) i have a list of products (PRODUCT NAME FRENCH) with some fields describing each product along with a field named PROJECTNAME which will "classify" evey product under a specific project.

I need the text (the name of the project) entered by the user on the PROJECT form (on the PROJECTNAME textbox) to be stored automatically as a record on every PRODUCT (under the field PROJECTNAME on the ENGINEERING table).

So that i can design a query that will give the user every product wich belongs to THAT project name he first specified.

Can this be done? Could i get help me with some code?

Thanks

[Stwange]

If you store the project name on EVERY product, ie product.PROJECTNAME will be equal to this text field all the way down the table, then there is little point running this query because it will just return every product. Are you sure this is what you want to do?

[Gilberto]

If you store the project name on EVERY product, ie product.PROJECTNAME will be equal to this text field all the way down the table, then there is little point running this query because it will just return every product. Are you sure this is what you want to do?

You are totally right i was just hoping that it would store that projectname for every product UNTIL the user entered another projectname under the PROJECT form (ie when the user enters all the project products and finalizes THAT project)

But then this also brings the issue that PRODUCT NAMES CANT be repeated, which will cause a conflict when a new project is created.

I really dont undestrand how i can address this issue. Please let me know if you undestand my logic and could suggest any alternative.

TO CLARIFY
when the user opens the database the PROJECT form opens asking him to SELECT/CREATE a PROJECTNAME then a button on the same form will take him to the ENGINEERING table where he can start entering/modifying PRODUCTs, their weight, density, etc, etc.
I need to be able to classify evey PRODUCT under its specific project so that i can print reports on ONLY the products belonging to a specific PROJECTNAME.