Combo Box Problem

  • Thread starter Thread starter Apprentice
  • Start date Start date
A

Apprentice

I have a form with an unbound combo box that is used to look up records from
a single table. The source for the combo box is a query [CHLookup] that
pulls directly from the table. The query works great, but when I use the
query as the row source for the combo box, the 1st column appears with its
lable... but not data. All the other (4) fields are populated except for
column (1). this is really wierd. I have another form set up the exact same
way using another query/table.

What would make the 1st (bound column) appear with not data in it and all
the others appear fine?
 
Check the combobox's properties. Specifically, look at Column Width and
Bound Column.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Column Width is fine. I have tried several differant widths... no luck. The
bound column is (1) which is Charter_ID. I have also compared the form and
combo box properties with the other look up form I built that works perfect.

I read something awhile ago that was talking about a bug with the Windows
service patch 3 or 2 and somthing about it effecting this specific problem
with Access (2003 Pro). It said something like being able to roll back to
the previous service pack..

I wasn't convenced.

Thanks for your help.... stay with me, I think someone can crack this!
--
Your guidance is greatly appreciated!


Jeff Boyce said:
Check the combobox's properties. Specifically, look at Column Width and
Bound Column.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Apprentice said:
I have a form with an unbound combo box that is used to look up records
from
a single table. The source for the combo box is a query [CHLookup] that
pulls directly from the table. The query works great, but when I use the
query as the row source for the combo box, the 1st column appears with its
lable... but not data. All the other (4) fields are populated except for
column (1). this is really wierd. I have another form set up the exact
same
way using another query/table.

What would make the 1st (bound column) appear with not data in it and all
the others appear fine?
Click to expand...
Click to expand...
 
For what its worth here is some more information:

SQL Code for Row Source on Combo Box:

SELECT CHLookup.Charter_ID, CHLookup.Fiscal_Year, CHLookup.Review_Title,
CHLookup.Team_Leader, CHLookup.Program_Reviewed
FROM CHLookup
WITH OWNERACCESS OPTION;

Relationships:

Table [Charter_Header] with Primary Key [Charter_ID]

Query CHLookup....from [Charter_Header]: ... with [Charter_ID],
[Fiscal_Year], [Review_Title], [Team_Leader], [Program_Reviewed].

Form will not show [Charter_ID]. I have tried several differant settings on
the form and on the combo box.

Help!




--
Your guidance is greatly appreciated!


Apprentice said:
Column Width is fine. I have tried several differant widths... no luck. The
bound column is (1) which is Charter_ID. I have also compared the form and
combo box properties with the other look up form I built that works perfect.

I read something awhile ago that was talking about a bug with the Windows
service patch 3 or 2 and somthing about it effecting this specific problem
with Access (2003 Pro). It said something like being able to roll back to
the previous service pack..

I wasn't convenced.

Thanks for your help.... stay with me, I think someone can crack this!
--
Your guidance is greatly appreciated!


Jeff Boyce said:
Check the combobox's properties. Specifically, look at Column Width and
Bound Column.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Apprentice said:
I have a form with an unbound combo box that is used to look up records
from
a single table. The source for the combo box is a query [CHLookup] that
pulls directly from the table. The query works great, but when I use the
query as the row source for the combo box, the 1st column appears with its
lable... but not data. All the other (4) fields are populated except for
column (1). this is really wierd. I have another form set up the exact
same
way using another query/table.

What would make the 1st (bound column) appear with not data in it and all
the others appear fine?
Click to expand...
Click to expand...
Click to expand...
 
I evan tried pulling straight from the table [Charter_Header].... nothing.
--
Your guidance is greatly appreciated!


Apprentice said:
Column Width is fine. I have tried several differant widths... no luck. The
bound column is (1) which is Charter_ID. I have also compared the form and
combo box properties with the other look up form I built that works perfect.

I read something awhile ago that was talking about a bug with the Windows
service patch 3 or 2 and somthing about it effecting this specific problem
with Access (2003 Pro). It said something like being able to roll back to
the previous service pack..

I wasn't convenced.

Thanks for your help.... stay with me, I think someone can crack this!
--
Your guidance is greatly appreciated!


Jeff Boyce said:
Check the combobox's properties. Specifically, look at Column Width and
Bound Column.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Apprentice said:
I have a form with an unbound combo box that is used to look up records
from
a single table. The source for the combo box is a query [CHLookup] that
pulls directly from the table. The query works great, but when I use the
query as the row source for the combo box, the 1st column appears with its
lable... but not data. All the other (4) fields are populated except for
column (1). this is really wierd. I have another form set up the exact
same
way using another query/table.

What would make the 1st (bound column) appear with not data in it and all
the others appear fine?
Click to expand...
Click to expand...
Click to expand...
 
Apprentice said:
I have a form with an unbound combo box that is used to look up records
from
a single table. The source for the combo box is a query [CHLookup] that
pulls directly from the table. The query works great, but when I use the
query as the row source for the combo box, the 1st column appears with its
lable... but not data. All the other (4) fields are populated except for
column (1). this is really wierd. I have another form set up the exact
same
way using another query/table.

What would make the 1st (bound column) appear with not data in it and all
the others appear fine?
Click to expand...


Access 2003, with SP3 applied? If so, it sounds like this issue:

http://support.microsoft.com/kb/945280/
Combo box controls and list box controls display no value or incorrect
values in Access 2003 after you install Office 2003 Service Pack 3


If that's it, apply the hotfix that is linked near the bottom of the
article.
 
Yes.... Yes! Thankyou. You Sir, convenced me and that was exactly right.
The HotFix worked like a charm.

Thank You Dirk!

Cheers!
--
Your guidance is greatly appreciated!


Dirk Goldgar said:
Apprentice said:
I have a form with an unbound combo box that is used to look up records
from
a single table. The source for the combo box is a query [CHLookup] that
pulls directly from the table. The query works great, but when I use the
query as the row source for the combo box, the 1st column appears with its
lable... but not data. All the other (4) fields are populated except for
column (1). this is really wierd. I have another form set up the exact
same
way using another query/table.

What would make the 1st (bound column) appear with not data in it and all
the others appear fine?
Click to expand...


Access 2003, with SP3 applied? If so, it sounds like this issue:

http://support.microsoft.com/kb/945280/
Combo box controls and list box controls display no value or incorrect
values in Access 2003 after you install Office 2003 Service Pack 3


If that's it, apply the hotfix that is linked near the bottom of the
article.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top