Access 2003 Database loses function

  • Thread starter Thread starter jeremycaff
  • Start date Start date
J

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
 
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)
 
Doug,

This worked - thanks

Douglas J. Steele said:
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)
Click to expand...
 
Back
Top