Drop Down Menu selection appears on all records

[nobuhle]

Hello. I am just learning Access, teaching myself actually. In the database I've created, I've added a combo box to some of the forms that allows me to select answers from a drop down menu. When I select an item from the drop down menu, that value appears on every record which prohibits me from entering the correct data in the field.

For example: I have one table called "Inventory" which contains a "Category" foreign key. I have a "Categories" table only consisting of only a primary key field and a "category" field. I've already populated all the fields there. On the "Inventory" form I created, I added a "Category" field. I already created a relationship with the category field of the categories table to the Category_FK field of the Inventory table. On the form, the drop down displays properly and allows me to select the criteria, however, when I go to another record and try to enter a different category, the latest selected category applies to all the records stored in this table.



I'm sure there is an easy solution to this. I just can't seem to find it. Is there anyone there who can assist me with this issue?

[pbaldy]

On the form, does the combo have a control source of the field in the table? Doesn't sound like it.

[John_G]

This will happen if your combo box is not bound to a field in the form's underlying table or query. Check the "Control Source" property of the combo box.

John

[nobuhle]

Yes. The control sourse is Category_FK

[nobuhle]

I've verified that the control source is "category_FK"

[pbaldy]

Is that the field in the category table or the field in the inventory table (which is what it should be)?

[pbaldy]

Can you post the db here?

[John_G]

Two questions -

What is the record source for your form - table or query?

Is there any VBA code in the category combo box that runs after you make a selection from it?

One possibility is that the relationship is wrong. Make a backup copy of your database, and then delete the relationship to see if that has any effect. I said make a backup because without seeing your database, it's hard to know what side-effects deleting the relationship might have.

John

[nobuhle]

It is in the inventory table. I tried to send the db but the file size was too big so I'm sending a couple screen shots. Hopefully i'm sending the info that answers you.

[nobuhle]

The record source is the Inventory. I didn't write any VBA code...don't know how. I've uploaded some screenshots to pbaldy. Can you tell if any code is written on these screenshots? I couldn't upload the db bcuz the filesize was too big.

[June7]

From what I can see in the images, the setup looks proper.

Did you run Compact & Repair then zip the file? 2MB zip allowed. Unless you have a LOT of records, 2MB should be enough, otherwise make copy and delete some records.