Access 2003 Database loses function

[jeremycaff]

G'day all,

I have a simple dtatbase that I designed several years ago and all has been
great. However, recently and without warning some of the db form functions
suddenly stopped working. Specifically there is a combo box, populated from a
qry that lists entries, when selected and cmd btn is pressed the id
associated with the selection in the cmb box opens another form containing
the data associated with the record id. Now the cmb box in the first form is
unpopulated so there is now way of getting to the other form to show the
data.

tbl data and qry function, rebuild of the original form doesn't work either.
A new form with a list box does work as a temp fix, but you have to scroll
through all the records.

Only thing that seems to have happened coincidental with the beginning of
the problem was the update to XP Pro SP 3.

Are there any known issues with updates that may have cused this before I go
in and try and pick it apart?

Thanks,

Jeremy

 

[Douglas J. Steele]

When you say that the combo box is unpopulated, do you mean there's nothing
in it the combo box, or does the combo box appear to have multiple rows, but
no values appear for any row? In either case, try the post SP3 hotfix at
http://support.microsoft.com/kb/945674 (especially if it's the second
problem I describe)

 

[jeremycaff]

Thanks Doug - I'll try and let you and all know.

Jeremy

 

[pcbins]

This 945674 did not work on all my combo boxes. Is there another fix for this
fix?

 

[jeremycaff]

Doug,

This worked - thanks

When you say that the combo box is unpopulated, do you mean there's nothing
in it the combo box, or does the combo box appear to have multiple rows, but
no values appear for any row? In either case, try the post SP3 hotfix at
http://support.microsoft.com/kb/945674 (especially if it's the second
problem I describe)