Search results

This is sooo weird. Now that you mention it does matter. I went and checked the AreaCategory table. It did update my table correctly! Question 1. Why is it doing this??? Why does the AreaCategory split form not reflecting the AreaCategory table which store the selected value correctly????? Is...

If you open the form from my sample file and start enter 2 or 3 entries as you keep an eye on the split form at the bottom. You will see my problem.... the value of CategoryName column just wouldn't stored in the table :(

The form is intentionally created as a split form because I want to give users the opportunity to sort existing records from the entry screen. Is there a reason why I should change the default form view to a single form etc?

Sorry for not making myself clear. If you notice from the split form. Every time I select the value, my whole CategoryName column is updated with that value. You are correct. The combo boxes work fine, my only problem is that every time I select the category in the second box, it updates my...

I am using access 2007. I have two combo boxes displaying values from two different tables. One box is depending on the other and they are on the same form. How do I store the values that user selected on this form to a third table? (see attached file for an example) Table1: Areas Table2...

I went a head and created a similar dummy db in Access 2000 and uploaded it here. Can you tell me how I can store user selection (Area & Category) to AreaCategory table?

I tried linking it without any referential integrity and still didn't work. I played with this again today and it seemed like the problem was coming from "Requery." Here was what I tested: If I took out the Requery code in the first combo box's After Update then I was able to select my option...

Thank you, Marianne! I will try that and let you know how it goes tomorrow.

All I have in the db relationship for these two table is linking of the Area_ID from two tables together. I tried a couple different join (inner join, left, right, outter) Is this what messing up my table?

Does it matter if I use Event Procedure or a Macro to do Requery? I tried both... and have been doing research/googling for 3days but no luck.

No, no specific update query. The only thing that consider as an "update" in this case is the Requery code I put in the Area_Combo After Update event so that the Category_Combo box can be refreshed with new Category basing on the user's selection of Area_Combo. (this is in case user changes...

It looks something like this.... Before entering new record or selecting Category or change category on an existing record: [CATEGORY TABLE] Category_ID---Category---Area_ID 1-------------Catg XZY---11 2-------------Catg ABC---22 3-------------Catg YYY---33 4-------------Catg KKK---44 Before...

That is right. All of my previous records in the Categories table | Category field/column is updated with the new selection for new entry. I'm not sure why and how to fix this... :( It doesn't matter if I add a new entry or go to an existing entry and change the value of the Category_Combo...

I apologize. I forgot to mention that I am using Access 2007. I just try to save a copy of my db in version 2000 for you but it wouldn't let me because there are some features in the db that require my current file format. Let me go over what I coded for each combobox to see if it helps...

I have two comboboxes linked together on a data entry form. The second combobox data is populated depending on the the user's selection in the first combobox. For example: **1st Combobox: Area_Combo **2nd Combobox: Category_Combo If user selects one of the option from the Area Combo box, the...