Same Problem

[DJS]

. Reply (E-mail) Forward (E-mail)

Subject: Re: Access 2000 Combo Box Problem
From: "(e-mail address removed)"
<[email protected]> Sent: 12/28/2003
11:08:41 AM




I've done as you suggested. The bound column is correct.
I'm still having the problem.

I may not have been as specific as I should have with my
last post. Perhaps some clarification will help.

I stated that the wrong information was appearing. The
field is showing information from a totally different
record, not data from the same record. Also, if I try to
type a specific name into the field, "Smith," for example,
I will get the proper name - until I hit "Enter" or move
to another field - then the data will change to another
name, such as "Jones."

Any ideas?

Thanks....

-----Original Message-----
You should check the bound column property of your combo box. Whatever the
value of the bound column is will be what is stored in the field. Usually
combo boxes hide their first column by setting the column width properties
and making the first column 0" wide. Check your combo boxes bound column and
column width properties to get a clear picture of what it's doing.




.

..

 

[Kevin Sprinkel]

Be sure to post a thread continuation as a Reply, so that
any potential respondants can follow the thread. Not
having read the original, I can't be sure of your problem,
but the symptom is consistent with placing a subform on
another form, and not setting the Link Master Field and
Link Child Field form properties, or not including the
linking field in the underlying table or query of the main
and/or sub form.

HTH
Kevin Sprinkel
Becker & Frondorf