Form only saves last entry selected from drop-down combo box

[nycdotnewbie]

I created a form that is linked to a table with a concatenated field. The concatenated field is what is linked to a drop-down combo box on the form where the user can select the item he/she is to update. Once the user selects it, they can type in a text box the # of units for the item selected. So....I click and item, let's say 8399 and then add 2 units, click save. Now, I select from the drop down menu 8400 and add 4 units, click save. When i run the report, my form only saved my last entry (8400 with 4 units). Why????

[aamirmit]

you are not saving the value in database correctly. is it possible that you show me your code??

[zmbd]

I created a form that is linked to a table with a concatenated field.

More than likely it is because you are directly editing the underlying record set in a bound control.
If this is your very first database, I suggest that you work thru the following:
> A Tutorial for Access
> Database Normalization and Table Structures.
I also highly advise that you take a few momements, scroll to the bottom of this page, click on the VBA Insights Sitemap link. A very large number of your future questions will have some answer sitting there and will save you hours of searching.

[nycdotnewbie]

Where do I find the code?

This is my first database.

[zmbd]

@nycdotnewbie
Hence why you should go to the tutorial site I linked you to and then read thru the second link.

You might also want to work thru the Access material:
Download Office 2010 training


As for the "Code" that aamirit is asking for... lets' skip that for now until you get the basics down.

You'll also want to be reading:
> Posting Guidelines
> How to ask good questions
> FAQ
> Before Posting (VBA or SQL) Code

[nycdotnewbie]

I appreciate your suggestions but I don't have time for that. I just need to get that form working as soon as possible.

[zmbd]

These are not suggestions; we cannot teach you the basics which are REQUIRED before you could even begin to understand what we would even try to tell you...

No disrespect intended (and I really do mean this in kindest way possible):
You can't even find the code behind the form, if any, and it sounds more like you used the form wizard which in V2010 seems to like the Macro script. Do you even know the difference between the two (VBA and Macro)?

Worse yet, because you do not have the basics down, your question is not really one that we can provide any real guidance for because you have not been able to relate the underlying structure of the form; something that you more than likely do not realize because you do not have the fundamentals.

Please understand we do truly want to help you; however, much like in a mechanics shop, you have to "bring your own tools" so to speak and understand what a spanner is versus a hammer and how to employ each of them for the task at hand.

I must now insist that you read the posting guidelines and the FAQ that were linked to in my last post. Please understand that you will be expected to abide by the standards given within for all further posts.

After that... you need to work thru the tutorials so that you can understand what we are telling you and more importantly, so that you can ask a proper question with the pertinent details.