By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,019 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

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

100+
P: 135
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
Sep 6 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 126
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?
Sep 6 '07 #2

100+
P: 135
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.
Sep 6 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.