Re: Combo Box Problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Charles (copratt_at_hotmail.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 19:45:12 -0400

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" <nospam_chief@smittysinet.com> wrote in message
news:v9idnbmOk7-09jfdRVn-gw@comcast.com...
> 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" <copratt@hotmail.com> wrote in message
> news:ekCgiMQPEHA.680@TK2MSFTNGP11.phx.gbl...
> > 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" <Tidepuddle@msn.com> wrote in message
> > news:4A7A8FFD-8E33-4CE7-9503-5B2943B77147@microsoft.com...
> > > 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.
> >
> >
>
>

Quantcast