When i change the bound column as you say, that solves the duplicate problem,
but then the ID shows up in the calories field, not what I want.

The tables are as I described and both id's are long integers.

The foodsort query sorts
1 food 2 calories 3 id to get the food in alpha order

On the Food Eaten form I placed one field - the calories field.

Then I created a combox box which used the foodsort query -
and it uses the 3 fields in the query - and I told it to fill in the
calories field.

When i do this, the Foodeaten form displays the food and its calories but I
still have the duplicate problem.

When I change the bound column as you suggested from 2 (calories) to 3 (id)
it then displays the food and its id and solves the duplicate problem, but I
want to see the food and its calories.

Pls advise

"Wayne Morgan" wrote:

It can be done, the trick is to get the bound column of the combo box to be
from a unique field. At the moment, I would guess that the bound column is
the Calorie field, so when you go back to look at the records, it displays
the first one it finds with that value for the calories.

--
Wayne Morgan
MS Access MVP


"FrankSpokane" wrote in message
...
Hi Wayne

I think my problem lies in how I want to see this info. Your explanations
and suggestions make perfect sense, but what I am trying to do is display
onscreen in the Food Eaten form the foods I ate for the day, and I have
the
form summing the calories. Everything id working except for my problem
with
foods that have the same calorie count.

This form is actually a subform on another form which shows my daily
mileage, times and other health related information. Thus this gives me
one
form to review for each days workout, and I have supporting reports also.

This is a very small app and I could email you a copy to explain better.

Maybe what I want can't be done.