A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combo Box Problem



 
 
Thread Tools Display Modes
  #1  
Old May 28th, 2004, 09:15 PM
Charles
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.