Add Multiple Values To A Textbox

[vazdajic]

Hello there.. Please help with the situation below:

[ssanfu]

Can't be done with existing design.

If you have an "M" entered in "Asset_01" because there are more than 1 assets (lets say there are 5 assets), what should be put in "Asset_01" when you delete all other assets? Remember, "Asset_01" now has a "M" in it. The "real" asset would be unknown.

Why not just add the 4 other asset controls to the first form?
(even though the table is not normalized??)


You really should read about normalization.
See
What is Normalization?
=======================
What Is Normalization, Part I: Why Normalization? http://rogersaccessblog.blogspot.com...on-part-i.html
What Is Normalization, Part II: Break it up. http://rogersaccessblog.blogspot.com...n-part-ii.html
What Is Normalization: Part III: Putting It Back Together http://rogersaccessblog.blogspot.com...-part-iii.html
What is Normalization: Part IV: More Relationships http://rogersaccessblog.blogspot.com...n-part-iv.html
What Is Normalization: Part V: Many-to-Many Relationships http://rogersaccessblog.blogspot.com...on-part-v.html

Read the tutorials and take the time to work through them at
http://www.rogersaccesslibrary.com/forum/forum46.html



BTW, "Name" is a reserved word in Access and shouldn't be used as an object name. Also shouldn't have spaces in object names.

[vazdajic]

Hello there.. I appreciate the answer but it can be done as I am using that piece of code but in the database which has visual basic locked so I cannot see the code. that database is created by Intergraph and I am not allowed to view/touch/modify the code..

[aytee111]

Your form design is based on normalization, your table is not. I suggest that you choose one or the other. If you keep your table design as it is then there is no point in being so fancy. Your table has 5 asset fields, add them all to the form so the user can enter them there. There is no need for the extra form as "multiple" is not true, there is a fixed number they can enter.