Access 2003 Combo Box

[mylewis]

Greetings all,
I am not a programmer who would appreciate any assistance available.

I have a table with 2 fields I have made combo boxed. Field 1 - staff
contact; Field 2 - local government.

Field 2 combo box is row source is from the local government contact. This
table has 5 fields
1. LGUID - primary key field
2. LGU name - text field
3. staff person name - test field
4. staff person region - text field
5. county - text field

I used the lookup wizard and select the fields LGUID and LGU name. The key
column is hidden as suggested.

The results that are returned are:

The field data type changes to number; and the combo box list is blank.

This list displays the names of all of the counties.

The field properties are:
Row Souce - name of the table
Bound column - 1
column count - 2
column head - no
column widths - 0";1"
list rows - 1"
limit to list - yes

I have tried countless options and am at a loss. I must make this database
available for staff within the next week.

Any help is greatly appreciated.




What I learned today I used yesterday; what I am being taught now will be
used tomorrow.

 

[Douglas J. Steele]

The fact that the combo box is blank makes me suspect that this is the bug
introduced by SP3.

See whether the hotfix at http://support.microsoft.com/kb/945674 solves the
problem.

 

[Allen Browne]

Open About on the Help menu, and see if it says you have:
Access 2003 SP3

If so, get this hotfix from Microsoft:
http://support.microsoft.com/kb/945674

More information about bugs in A2003 SP3:
http://allenbrowne.com/bug-Access2003SP3.html

 

[Klatuu]

In addition to what Douglas and Allen have suggested, I did notice an error
in your combo box propeties. You have

list rows - 1"

The List Row property should be an Integer value. It defines how many rows
will be displayed when you click the arrow to cause the combo box to drop
down. The default value is 8. Remove the " and allow more than one row.