Table Information No Longer Displayed

[TheScullster]

Hi all

We have an Access2000 database that we have been using for a number of years
now.
On one of the forms there is a combo box which displays a list of countries
which are associated with each of our Customer's address.
The row source for this control is a table tbCountry.
For some reason when we try to add a new customer and assign a country,
nothing is displayed in this combo box for selection.

This is a split database with the tbCountry table in the back end.
I have tried refreshing the link to the table with no change. However, if I
open the front end in design view, I can open the table via the link and the
country list is there.

Can anyone suggest why the table contents are not being displayed in the
combo box please?


TIA


Phil

 

[Guest]

How many columns does the table have and how many columns does the combo box
have? Which is the bound column? What are the column widths? Have you changed
Access versions since it worked before?

 

[TheScullster]

How many columns does the table have and how many columns does the combo
box
have? Which is the bound column? What are the column widths? Have you
changed
Access versions since it worked before?

Thanks for response mscertified

No changes have been made to the database directly, so I do not understand
why column widths/bound columns etc would have altered.
The only "system" changes that have occurred are:
Microsoft updates
One user now connects to the back end using the same front end but running
on Access2007 (all other users have Access2003)

Will check the column info on Monday and revert

Phil

 

[George Nicholson]

Users have 2003?

In that case, what you are seeing might be one of the known bugs caused by
Office 2003 SP3.
http://allenbrowne.com/tips.html
(This would also explain the "no changes except MS updates")

From reading other posts, it seems that the suggested fix is to open the
backend and remove any
formatting applied to the problem field at the table level and then reapply
any formattinge needed at the form/control level.

However, if your 2007 user has the same problem, this might be the wrong
tree to bark at.

 

[TheScullster]

Users have 2003?

In that case, what you are seeing might be one of the known bugs caused by
Office 2003 SP3.
http://allenbrowne.com/tips.html
(This would also explain the "no changes except MS updates")

From reading other posts, it seems that the suggested fix is to open the
backend and remove any
formatting applied to the problem field at the table level and then
reapply any formattinge needed at the form/control level.

However, if your 2007 user has the same problem, this might be the wrong
tree to bark at.

George

Many thanks for comprehensive response.
Yes I tried this on a 2007 client and all is well so it looks like the bug
is to blame!
The formatting is simply a > sign to force upper case country names.
Will try removing this from the back end table when all users are out.

This may be a minor issue for a smaller player like us, but I could see this
sort of sudden change having major impact in very large multi-user
environments.

Excellent site that allenbrowne.com BTW.

Phil