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

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

P: 3
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????
Feb 25 '13 #1
Share this Question
Share on Google+
6 Replies


P: 1
you are not saving the value in database correctly. is it possible that you show me your code??
Feb 25 '13 #2

zmbd
Expert Mod 5K+
P: 5,397
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.
Feb 26 '13 #3

P: 3
Where do I find the code?

This is my first database.
Mar 5 '13 #4

zmbd
Expert Mod 5K+
P: 5,397
@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
Mar 5 '13 #5

P: 3
I appreciate your suggestions but I don't have time for that. I just need to get that form working as soon as possible.
Mar 5 '13 #6

zmbd
Expert Mod 5K+
P: 5,397
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.
Mar 5 '13 #7

Post your reply

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