If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo Box Problem
I converted the database to Access 2002 and the problem still persists.
I updated Access 2002 with the latest Office updates and the problem still persists. "Charles" wrote in message ... Upon further reflection, I don't think its really trying to update the Customers table, I think its just simply dropping the CustomerID from the combo box for some unseen reason. It most likely is that simple. Perhaps the form has too many combo boxes, too many fields, too many pages...who knows? "Charles" wrote in message ... All of your assumptions are correct and I share your sentiments as to why the combo box is trying to duplicate a field in the customers table as apposed to the orders table. All my tables are based upon and set up exactly like the Northwind database, no rocket scientry going on here. It seems to me I have reached some inherent limitation that I am not aware of that is causing this problem. Perhaps if I had an idea of what limitation it is I'm running into I could attempt to work around it, but I have no clue where to start unfortunately. As far as changing the tab order, it was suggested to me to do it programatically using the OnOpen event which I will sure give a try. Thanks to all who have tried to help me with this glitch. Anymore ideas will get serious attention and would be greatly appreciated. Charles "Reggie" wrote in message ... Not sure then. I assume you have a combo box on your form to allow the user to select a Customer for the current record and that this combo is populated by the Customer table or a query/sql based on the customer table. I also assume you have the Control Source for the combo box set to the CustomerID field of the table/query/recordsource on your form. When you select a customer from the combo that value is stored in the CustomerID field of the recordsource you are working with. My confusion comes with how/why is the procedure trying to set/change the value in your Customer table? Without knowing more about how your application is setup I can't offer much more assistance. Sorry! -- Reggie www.smittysinet.com ---------- "Charles" wrote in message ... My tables are set up fine and the combo box has always worked just fine in the past. I have recently added some new fields, changed some fields from labels to text boxes to combo boxes, and even added some code behind them. All of these changes work fine and the form does what it is suppose to do. No problems result from any of these changes made to the form. After many hours of working on this problem I have finally dwindled it down to the following event: As soon as I go in to change the tab order (under the "View" menu, I choose "Tab Order", then I click on "Auto Order") thats when the problem occurs. I return to the form then click on the "Duplicate" button, the combo box that holds the Customer ID goes blank and I am stuck in the aforementioned catch 22. I literally have to delete the form entirely and restore from a backup just to get the thing to work again. I know there is no reason to the ryme here and am completely frustrated, any additional ideas would be wonderful? As it sits now, the form is working fine, unfortunately, when the user tabs from one field to the next, it sends them all over the form and is just awful as you can imagine. I have tried manually changing each individual fields "Tab Index" but this is screwed up as well because as soon as you change one it changes all the rest of the fields "Tab Index" number to some other number. Unbelievable! "Reggie" wrote in message ... If CustomerID is your primary key how/why do you think you can duplicate it. Primary keys cannot have duplicates. It appears you are trying to add a new record and duplicate the primary key. I think you have your relationships/table setup wrong. Looks like you need something like this: Here's the relevant tables and field names: tblCustomers CustomerID* tblOrders OrderID* CustomerID(foreign key) ... ... tblOrderDetails OrderDetailsID* OrderID(foreign key) txtPartNo .... .... Now when you duplicate the record the Customer will be brought forward. This may not be exactly what you are looking for but something like this. Reggie www.smittysinet.com ---------- "Charles" wrote in message ... This has nothing to do with adding New records. I am referring to the behavior of a combo box when you duplicate a record (using a duplicate button created by the button wizard). The original contents of the combo box is dropped. When you try to change it back, you will see an error message at the bottom of the page that says "To make changes to this field, first save the record." Well you can't save the record because a Null value doesn't exist for that field so it won't let you save. You end up in a catch 22 with this unknown behavior. Has anyone had this problem yet? "Tidepuddle" wrote in message ... Just set the customer ID number to be re-enter automatically. New records have to have a default or a value reset, otherwise you get a blank. |
Thread Tools | |
Display Modes | |
|
|