Form Help with updating columns

[Gumbyu]

Hi.

I am a newbie and am trying to build a form for a daily dietary menu.

The problem I am having is that the form, which is based on a query to the primaryfood table does not update all the rows, based on the food.

To explain, I have 4 columns and a primary key in the table (AutoNumber). The query call all the fields.

The form then has for distinct columns:
Food Name
Fat Grams
Carb Grams
Calories

The form is in an Excell type format.

The problem is that when I use a list box and either search and select the food name, say, Big Mac with Cheese the Food column in the form changes but the corresponding values for the fat, carbs, etc doesnt. How can I make the form do that?
Any help or hints will be appreciated.

-Bob

[missinglinq]

If I understand your post, you want to select a food and retrieve the associated dietary values, i.e. grams of fat, protein, carbs and so forth. If this is correct, the easiest way would be to use a combobox instead of a listbox, and leave the creation of the retrieval process to Access, by way of the Combobox Wizard.

First you must have your form set up to display the records you want to retrieve, i.e. the form's Record Source should be the table/query that holds the data. You must have textboxes that have as their Control Sources the fields for fat, protein, carbs and so on. Then simply:

Add a combo box to your form. The Combobox Wizard will pop up.
Select "Find a record based on the value I selected in my combobox."
Hit Next.
The table/query that the form is based on will be selected and the fields will be listed on the left hand box. Click on the field you're searching by (in this case the FoodName field) to move it to the box on the right.
Hit Next.
Size the column to show the fields. This works just like sizing columns in Excel or in a datasheet form in Access.
Hit Next.
Name the combobox.
Hit Finish.

Now you can drop the combobox down and scroll down to the item to search by, or you can start to type in the item, and the combobox will "AutoComplete" as you type (an advantage the combobox has over the listbox.)
Hit <Enter> and the record will be retrieved with fat, protein, carbs etc filled in.

You're done!

Welcome to TheScripts!

Linq ;0)>