Wrong value in a Table from a combo box

[JonathanT]

I have a combo box on a form whose record source is Table 1. The combo box pulls values from an Item table. The field selected in the combo box that I want to store in Table 1 is ItemCalories. However when I add the ItemCalories to a record the ItemID is what gets stored in Table 1, not the ItemCalories even thought ItemCalories is showing in the combo box. I cannot figure out how to get the ItemCalories stored in Table 1. DB attached

[Bob Fitz]

Sorry, but IMHO you need to start again. Read up on DB design and relationships. I believe you need more tables e.g. MealTypes and FoodTypes

[Welshgasman]

I have a combo box on a form whose record source is Table 1. The combo box pulls values from an Item table. The field selected in the combo box that I want to store in Table 1 is ItemCalories. However when I add the ItemCalories to a record the ItemID is what gets stored in Table 1, not the ItemCalories even thought ItemCalories is showing in the combo box. I cannot figure out how to get the ItemCalories stored in Table 1. DB attached

Sounds like you have table lookups, which are not advised.
You actually want the ID, then refer to that ID in the relevant table.

EDit:
Not withstanding Bob's comments, you have bound the incorrect field?
I do not see how any of that form is actually meant to work?

I do something similar for my diabetes, but I have one record per item per meal, and then I just sum the carbs. I do not store them?

[Bob Fitz]

Sounds like you have table lookups, which are not advised.
You actually want the ID, then refer to that ID in the relevant table.

Hi Welshgasman. I thought the OP may have table lookups but I couldn't actually find any. However, as I stated in my earlier post the db design leaves much to be desired, IMHO.

[Bulzie]

Go look at the combo properties, looks like it has 2 fields or more ItemID and ItemCalories and ItemID is the bound field although ItemCalories is the field showing. You do not need the ItemID field in the combo box if you want to just store the ItemCalorie value. So make the number of fields 1, remove the ItemID and remove the ItemID Length value. (or redo the combo box and only select the ItemCalories field.)

[Welshgasman]

Yes Bob, thay was my first thought, but I then downloaded the db, and it was a simple bound field problem.

[JonathanT]

This DB was just to illustrate the problem. The DB I am working with had too much proprietary info to post here. The problem I had was an incorrect order in the query builder fields of the combo box and the wrong bound column. Thanks for all the replies. Problem solved.